Recent content by gtj_global

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]...

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...

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...