Limiting records returned from query

  • Thread starter Thread starter Mike M.
  • Start date Start date
M

Mike M.

I have an art gallery database query that looks for sales of items but
returns not only the final sale , but all instances of times that item was
entered in a show but not sold. I.E., if an item finally sells in show 4,
the query shows results for shows 1, 2, 3, and 4, since it was entered in
all 4 shows.

I tried to incorporate a where statement into the SQL statement to limit the
show to max(ShowId) because it is always the last time shown when the actual
sale occurs, but I can't seem to get the syntax right, and I don't know if
I'm on the right track to begin with.

Any ideas would be helpful.

Mike
 
Posting a copy of your SQL statement would give us a bit more to go on...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Please post your Table details and the best-attempted SQL you have done on
this query.

This way, potential respondents have more information to work on and can
suggest as close as possible to what you want rather than a general
proposal.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repost-Edit and save query criteria 5
Two tables, multiple relationships? 1
Computing total sales with a query 2
Normalizing Monthly Sales Data 5
Parameter Query: Limit Parameter 7
Returning A Varibale from a query 1
total a query 1
IIf statement in query criteria 3

Back
Top