J
Jimmy
I have a query that pulls a bunch of information for the year. I need to
create a report that counts the number of referrals year to date and for the
last 30 days. In the query design I hit the totals button and change the
date field to count. This counted the number of records perfectly for the
ytd number. I also created another query off the one I just did but put the
formula: >=DateAdd("m",-1,Date()) in the criteria of another of the same
date field I added to the query but am not showing. How can I get my report
to show the count function of the YTD numbers and the last 30 days numbers.
Everytime I try to add an unbound text box and point it to the last 30 days
count it comes back invalid. Please HELP!!!
create a report that counts the number of referrals year to date and for the
last 30 days. In the query design I hit the totals button and change the
date field to count. This counted the number of records perfectly for the
ytd number. I also created another query off the one I just did but put the
formula: >=DateAdd("m",-1,Date()) in the criteria of another of the same
date field I added to the query but am not showing. How can I get my report
to show the count function of the YTD numbers and the last 30 days numbers.
Everytime I try to add an unbound text box and point it to the last 30 days
count it comes back invalid. Please HELP!!!