I have a report already created based on a crosstab query. one of the fields in the report is [region]. In the table the query draws from, there is a field regionid, a number. I cant get it into the report because of rowheading limitations of the crosstab. I have tried to write code assigning each region a number (corresponds to the regionid), but having trouble with correct commands for the event procedure (report, on open is what i used). also tried an unbound control for regionid with a dlookup to the table, but continually get #error. I have tried all variations of syntax but still get the error message. Not sure what I am doing wrong, but think the event procedure is best way. any good advice appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CREATING UNBOUND CONTROL IN AN ACCESS REPORT
- Thread starter STRATMAN1
- Start date
How many Row Headings do you have? I didn't know there was a limit.
You could combine the Region into another Row HEading, like
Blah (Northwest)
Blah1 (SouthEast)
etc
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
You could combine the Region into another Row HEading, like
Blah (Northwest)
Blah1 (SouthEast)
etc
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
- Status
Similar threads
- Locked
- Question
- Locked
- Question