Not sure what I'm doing wrong, is it possible to enter a parameter box on a crosstab query?
Not sure what I'm doing wrong, is it possible to enter a parameter box on a crosstab query?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
For anyone that would like to know a quick and simple answer to this question is yes it can be done just as any other qry parameter box
What was it that you initially did wrong in your Cross Tab Query?
I'm not really sure why it wouldn't work the first few times I tried, but initially it would not recognize the parameter request of [Enter Claim]. This is an inherited database so I wasn't sure what took place in the development. I reviewed the SQL query, everything looked fine. I removed all criteria, closed the db, reopened it and reinserted the criteria . . . it works fine now. . . just a hiccup I guess.