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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crosstab report with data from multiple locations
Thank you dhookom! That was just what I needed. I also added WHERE (((Year([ChangeDate]))=[Enter Year])) to the first two queries so that I would get the results for only the year of interest.- greenche
- Post #7
- Forum: Microsoft: Access Reports
-
Crosstab report with data from multiple locations
When I set the join properties, I get a message that "The SQL statement couldn't be executed because it contains ambiguous outer joins."- greenche
- Post #5
- Forum: Microsoft: Access Reports
-
Crosstab report with data from multiple locations
Based on your suggestions Randy, I ended up with a make-table query for orders, an append query for change orders, and a crosstab query based on the resulting table. I wasn't sure where to put the macro code shown in your FAQ for complex reports, but I managed to do the same thing with a macro...- greenche
- Post #3
- Forum: Microsoft: Access Reports
-
Crosstab report with data from multiple locations
I am trying to generate a crosstab report for monthly sales grouped by product category that looks like this: ReportingGroup Jan Feb Mar Apr May Jun ... Group1 2000 4000 Group2 3050 3000 Group3 Group4 4000 5000 5000 5000 5000 5000 Group5 The...- greenche
- Thread
- Replies: 6
- Forum: Microsoft: Access Reports
-
Open a form showing last record entered
Actually in a form, you are right, this wouldn't work: DoCmd.GoToRecord acDataForm, "name of your table", acLast It should be: DoCmd.GoToRecord acDataForm, "name of your form", acLast- greenche
- Post #8
- Forum: Microsoft: Access Forms
