I have looked at your db and you will have issues sorting in a query as you have demo'd in Table 2. You have text for your clients, ie. client 1, client 2, etc. This data will sort in this manner, client 1 , client 10, client 11, client 2, client 20, etc. You will need to change your fields to remove the descriptor from the field data. This is true for all fields that you have set up this way. Once you set your data in the appropriate manner, you can then query the table.
Your query would resemble this.
BTW, the word today is a reserved term in Access and should be avoided as it may cause issues.Code:SELECT Today.ID, Today.Duration, Today.Client, Today.Project, Today.Task, Today.Narration, Today.Date1 FROM Today WHERE (((Today.Duration) Is Not Null)) ORDER BY Today.Client, Today.Project, Today.Task;




Reply With Quote
Bookmarks