briantjohnson
Registered User.
- Local time
- Yesterday, 20:28
- Joined
- Nov 21, 2019
- Messages
- 26
Folks,
I have a report that's done sterling service for some years (Access 2003). The detail is currently sorted by info in the report record source, a number descending (raced) and then another number ascending (pos). There's a new requirement to add another sort (or group?) before these two. It's to test the value of 'raced' against a value obtained by a DCount in the report header and then used to populate a text box in the header (txtlatestrtc) ...
I have tried things like =[Raced]>=[txtlatestrtc] in both the report Order By and Sorting and Grouping areas. I generally get "Reserved Error" ...
Am I trying to do the impossible?
Thanks for any insight
Brian
I have a report that's done sterling service for some years (Access 2003). The detail is currently sorted by info in the report record source, a number descending (raced) and then another number ascending (pos). There's a new requirement to add another sort (or group?) before these two. It's to test the value of 'raced' against a value obtained by a DCount in the report header and then used to populate a text box in the header (txtlatestrtc) ...
I have tried things like =[Raced]>=[txtlatestrtc] in both the report Order By and Sorting and Grouping areas. I generally get "Reserved Error" ...
Am I trying to do the impossible?
Thanks for any insight
Brian