Where function ???

  • Thread starter Thread starter fiaolle
  • Start date Start date
F

fiaolle

Hi
I'm using the functions Max and Where in my query to sort out some records.
I want the column with the Where function to be visible in my query, but
Access won't let me. It says I can add that column twice, but when I do the
query doesn't sort out the records it did before.

What can I do??

Please help!

Fia
 
Hi
I'm using the functions Max and Where in my query to sort out some records.
I want the column with the Where function to be visible in my query, but
Access won't let me. It says I can add that column twice, but when I do the
query doesn't sort out the records it did before.

What can I do??

Please help!

Fia
Click to expand...

Please post the SQL of your query, and enough information about the
table that someone who can't see your computer monitor might have a
chance to help. If you can explain what you mean by "doesn't sort out
the records it did before" as well that might help!

WHERE isn't a function, for one thing. The WHERE clause of a Query
lets you specify the criteria which determine which records are
included. In a Totals query, you can select "Where" on the same row as
you select Sum or Group By, but it's handled differently when you look
at the actual resulting query!

John W. Vinson[MVP]
 
Back
Top