Search results
-
G
Sorting of Total sum in report
Chris, My queries are below. The first query is the result of joining two tables (two parameters (1) choose family, (2) start and end date) PARAMETERS [Forms]![SingleReport]![cboStartDate] DateTime, [Forms]![SingleReport]![cboEndDate] DateTime; SELECT Family.Family, Family.[Item Code]...- gtj_global
- Post #6
- Forum: Reports
-
G
Sorting of Total sum in report
Hi Pat, Thank you for your reply. I have created the query to return the total and it returns the correct data. When I join the two queries and run it I get a "circular reference error." I am assuming because the first query must run first (to calculate the numbers), then the second query to...- gtj_global
- Post #4
- Forum: Reports
-
G
Sorting of Total sum in report
Hi Pat, I hope you don't mind me replying to this thread and not starting a new one, but I have the same problem. I have googled help on the topic and you've come up several times in the results. I have two tables and one query to bring them together. But I want to sum the total number of...- gtj_global
- Post #3
- Forum: Reports