K
Kay
Hi
I have created a query that counts the records between 2 dates that are
entered by the user. I get the correct output as a single number but I
want it to give me an output on a daily basis. For example if I want a
count for the last week, I want it to display the count for Monday,
Tueaday, wednesday........etc
Ive used 2queries. Q1 extracts all data and ive used many queris that
use Q1 to get their results but am having problems with this particular
one. The code in my second query is simple as follows:
SELECT Sum([Q1].[Current]+[Q1].[Bookings]+[Q1].[Contracts]) AS Jobs
FROM Q1;
(This query as I said gets me a single number that is the sum of all
the records(jobs))
Any help is much appreciated
I have created a query that counts the records between 2 dates that are
entered by the user. I get the correct output as a single number but I
want it to give me an output on a daily basis. For example if I want a
count for the last week, I want it to display the count for Monday,
Tueaday, wednesday........etc
Ive used 2queries. Q1 extracts all data and ive used many queris that
use Q1 to get their results but am having problems with this particular
one. The code in my second query is simple as follows:
SELECT Sum([Q1].[Current]+[Q1].[Bookings]+[Q1].[Contracts]) AS Jobs
FROM Q1;
(This query as I said gets me a single number that is the sum of all
the records(jobs))
Any help is much appreciated