Criteria for Date in query

[Baderinwa3]

I have a created a report for a query that determines the next delivery date
for patients medical supplies to be delivered. Now I want to create a
monthly report.

I have done various criterias and none have produced any data.
I have a used [Enter Start date] and [End Date] and have tried some rather
complex criterias, but when I press the execute button in the query I receive
no information. Can some help me out?

 

[Dale Fye]

Post the SQL that you have, and explain the criteria for this report.
You've indicated StartDate and EndDate fields, I would think there is also
some sort of field for the frequency with which the supplies are supposed to
be delivered.

By monthly report, do you mean you want to show all of the people that are
supposed to get something this month, and what it is, and on what date? Or,
do you want a report that shows each day, and the people/supplies that are
supposed to be distributed?

Dale

 

[Baderinwa3]

I am a little rusty in Access SQL? Can't remember exactly what that is. In my
query I have patient name supplies, datedeliverd, nextdateofdelivery. It
produces the information. In the datedelivered criteria area I typed [Enter
Start Date] and [Enter End Date]. I ran the execution no information was
found. I also entered cdate([EnterStart Date]) and
<Dateadd("d",1,cdate([Enter end date])) ran the execution no information was
found.

In my report you are right. Right now, it is just a report that has been
sorted. But I need the report to be printed every month instead of the all
the records printing out each month.

Post the SQL that you have, and explain the criteria for this report.
You've indicated StartDate and EndDate fields, I would think there is also
some sort of field for the frequency with which the supplies are supposed to
be delivered.

By monthly report, do you mean you want to show all of the people that are
supposed to get something this month, and what it is, and on what date? Or,
do you want a report that shows each day, and the people/supplies that are
supposed to be distributed?

Dale

--
Email address is not valid.
Please reply to newsgroup only.

I have a created a report for a query that determines the next delivery date
for patients medical supplies to be delivered. Now I want to create a
monthly report.

I have done various criterias and none have produced any data.
I have a used [Enter Start date] and [End Date] and have tried some rather
complex criterias, but when I press the execute button in the query I receive
no information. Can some help me out?

 

[Baderinwa3]

SELECT [Patient Information].ContactFirstName, [Patient
Information].ContactLastName, [Patient Information].DiabeticStrips, [Patient
Information].QTY4, [Patient Information].Lancets, [Patient Information].QTY5,
[Patient Information].DateofDelivery, DateAdd("m",2.5,[DateofDelivery]) AS
DeliveryDate
FROM [Patient Information]
WHERE ((([Patient Information].DiabeticStrips)="Strips") AND (([Patient
Information].Lancets)="Lancets")) OR ((([Patient
Information].DiabeticStrips)="Diabetic Strips"));

Post the SQL that you have, and explain the criteria for this report.
You've indicated StartDate and EndDate fields, I would think there is also
some sort of field for the frequency with which the supplies are supposed to
be delivered.

By monthly report, do you mean you want to show all of the people that are
supposed to get something this month, and what it is, and on what date? Or,
do you want a report that shows each day, and the people/supplies that are
supposed to be distributed?

Dale

--
Email address is not valid.
Please reply to newsgroup only.

I have a created a report for a query that determines the next delivery date
for patients medical supplies to be delivered. Now I want to create a
monthly report.

I have done various criterias and none have produced any data.
I have a used [Enter Start date] and [End Date] and have tried some rather
complex criterias, but when I press the execute button in the query I receive
no information. Can some help me out?