Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / December 2005

Tip: Looking for answers? Try searching our database.

Creating an Access Report with Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Wayne M - 04 Dec 2005 03:32 GMT
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!

Signature

Wayne M

Duane Hookom - 04 Dec 2005 04:25 GMT
Try uncheck the "Show".

Signature

Duane Hookom
MS Access MVP
--

>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
[quoted text clipped - 26 lines]
> message has introduced a bunch of confusion.  Any ideas will be quite
> welcome!
Wayne M - 04 Dec 2005 05:48 GMT
I tried that.  The results:
1. The same message appeared when I returned to the Report Design.
2. The 'ID' entry in the Query design grid had disappeared.
Thanks
Signature

Wayne M

> Try uncheck the "Show".
>
[quoted text clipped - 28 lines]
> > message has introduced a bunch of confusion.  Any ideas will be quite
> > welcome!
Duane Hookom - 04 Dec 2005 07:27 GMT
Reply with the sql view of your query.

Signature

Duane Hookom
MS Access MVP
--

>I tried that.  The results:
> 1. The same message appeared when I returned to the Report Design.
[quoted text clipped - 34 lines]
>> > message has introduced a bunch of confusion.  Any ideas will be quite
>> > welcome!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.