W
Wayne M
I received help a day or two ago. I'm still working on the same gas
consumption database I needed help before. Here's the confusion I'm facing
now:
When I closed the Query and returned to the Report design, Access displayed
“You tried to execute a query that does not include the specified expression
‘ID’ as part of an aggregate function or grouping.
‘ID’ is the Access assigned record number. In the Query design grid, I had
set its criteria to >1 to make sure the Query didn’t include the first record.
Here is the first column of the design grid.
Field ID
Table 96 Voyager-2
Sort
Show checked
Criteria >1
Or:
Apparently, I’m again missing something! Adding that criteria for ID seemed
to make sure no data from record #1 was included in the report, but this
message has introduced a bunch of confusion. Any ideas will be quite welcome!
consumption database I needed help before. Here's the confusion I'm facing
now:
When I closed the Query and returned to the Report design, Access displayed
“You tried to execute a query that does not include the specified expression
‘ID’ as part of an aggregate function or grouping.
‘ID’ is the Access assigned record number. In the Query design grid, I had
set its criteria to >1 to make sure the Query didn’t include the first record.
Here is the first column of the design grid.
Field ID
Table 96 Voyager-2
Sort
Show checked
Criteria >1
Or:
Apparently, I’m again missing something! Adding that criteria for ID seemed
to make sure no data from record #1 was included in the report, but this
message has introduced a bunch of confusion. Any ideas will be quite welcome!