Dueby
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 4 articles for 0.206 sec
There a couple of ways. You can use prompts for dates or use an unbound form to enter dates for the criteria. Here is how to use prompts -- WHERE (((tblMonthList.MyMonth) Between Format(CVDate([Enter start date]),"yyyymm") And Format(CVDate([Enter date date]),"yyyymm") )) And of course use a date format that Access will recognize. -- Build a little, test a little. "Rob" wrote     

Group: microsoft.public.access.reports · Group Profile · Search for Dueby in microsoft.public.access.reports
Author: KARL DEWEY
Date: May 13, 2010 16:02

I was wondering if I can bother the masters one more time about this? If it at all possible to make this part... (Between 200801 and 201012)... a user input with supplying a month and then the year instead of year and month, (i.e. 6-09, 10-10, etc.)? I only ask because I'm being asked and the four digit year preceeding the month has confused a few ppl. Thanks Again! Rob "KARL DEWEY"
Show full article (7.00Kb) · Show article thread
I got it to work! Yiippiieeeeee! Below is what the end result is... SELECT tblMonthList.DisplayMon, Sum(IIf(Format([Received Date],"mmm")=tblMonthList.DisplayMon,1,0)) AS [Qty Received], Sum(IIf(Format([DueBy Date],"mmm")=tblMonthList.DisplayMon,1,0)) AS [Has Due Date], Sum(IIf(Format([SentOn Date],"mmm")=tblMonthList.DisplayMon,1,0)) AS [Qty Sent] FROM qryDeliveries, tblMonthList     

Group: microsoft.public.access.reports · Group Profile · Search for Dueby in microsoft.public.access.reports
Author: Rob
Date: May 13, 2010 10:20

Awesome! Thanks! However there seems to be just one thing... SELECT tblMonthList.DisplayMon, Sum(IIF(Format([Received Date],"yyyymm")= tblMonthList.MyMonth, 1, 0)) AS [Qty Received], Sum(IIF(Format([DueBy Date], "yyyymm")= tblMonthList.MyMonth, 1, 0)) AS [Has Due Date], Sum(IIF(Format([SentOn Date],"yyyymm")= tblMonthList.MyMonth, 1, 0)) AS [Qty Sent] FROM [qryDeliveries], tblMonthList
Show full article (6.27Kb)
    

Group: microsoft.public.access.reports · Group Profile · Search for Dueby in microsoft.public.access.reports
Author: Rob
Date: May 13, 2010 06:35

Show full article (8.18Kb) · Show article thread
    

Group: microsoft.public.access.reports · Group Profile · Search for Dueby in microsoft.public.access.reports
Author: Rob
Date: May 13, 2010 06:24

Show full article (7.19Kb)