If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query Problem
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 |
#2
|
|||
|
|||
Query Problem
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). -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|