John Jnr
Registered User.
- Local time
- Today, 18:07
- Joined
- May 2, 2002
- Messages
- 36
This is probably going to be very simple?
I have written a query etc etc. All I want to do is within the query make the user select a year e.g. Expr1: [Select Year]
The query then selects the inputed year from the table field names and displays all the data from that year.
Every time I try this it puts the inputted year into every record line:
Expr1
2003
2003
2003
2003
I just want it to selct the feild name 2003 and then show all the data fromt that year.
Please help on this easy one but it is driving me nuts!
Thanks
Ps. This IS the best website, I am not just saying that. It is very rare these days to get help for nothing.
I have written a query etc etc. All I want to do is within the query make the user select a year e.g. Expr1: [Select Year]
The query then selects the inputed year from the table field names and displays all the data from that year.
Every time I try this it puts the inputted year into every record line:
Expr1
2003
2003
2003
2003
I just want it to selct the feild name 2003 and then show all the data fromt that year.
Please help on this easy one but it is driving me nuts!
Thanks
Ps. This IS the best website, I am not just saying that. It is very rare these days to get help for nothing.