Cannot get a user input box to open on a crosstab query

Randy

Registered User.
Local time
Today, 00:25
Joined
Aug 2, 2002
Messages
94
I have a crosstab query. users need to run the query for any week of a year. It is always a YTD query. I have used this process on many select queries. Will a crosstab query not support this simple method? See attached screen shots.
 

Attachments

Last edited:
never mind, when I set the parameters, I used text, it needed to be single. Works like a charm. for some reason I thought the field was reading as text.
 
ok for some reason a dialog box for [Enter Reporting Week] opens twice. see attached word document for parameter box and SQL code.
 

Attachments

Users who are viewing this thread

Back
Top Bottom