Query Problem

[Niall]

I have a query which shows me the following data:

Name 2003 2004 2005
Joe 5 6 7
Bob 8 9 10
James 1 2 3

These are the number of days absent by staff for the
respective year. I am now trying to build a query that
asks a user to select a year and will return the values
for that year, eg the user enters "2004" and the output is:

Name 2004
Joe 6
Bob 9
James 2

Would anyone have any ideas on this? much appreciated

Niall

 

[Jeff Boyce]

Niall

You haven't indicated whether this is a "cross-tab" query, or if your data
is organized like a spreadsheet. You haven't provided the SQL statement of
your query.

One approach might be to add a parameter in the criterion section of your
query definition. That parameter would prompt the user to enter a value (a
year), then return the values for that year. Can you add "2004" in the
criterion for your year in your current query and get the results you want?
If so, you can change "2004" to "[Enter a year]" (without the quotes).