query report off specific time frame

[kdoran]

I am trying to make a report that will query for specific times of the year what has been done and what has not been done. It would key off the checklist and and type of check.

tblFieldTag

FieldTagID
WeeklyCheck (yes/no)
MonthlyCheck (yes/no)
YearlyChekck (yes/no)
ValveChecklist (yes/no)
MCCChecklist (yes/no)


tblFieldNotes

FieldNotesID (autonumber)
FieldTagID (This is a required field)
FieldNotesDate
FieldNotesText


for example the Weekly Valve checks would be done monthly. I get how to search for a specific month by using between dates.

What I am having trouble with is how to write it so the supervisor can go to a form run a query and have the report ran for each month and not have to enter the date he is inquiring about. So for February he can so what was not done.

(this is one example of many checks that are required to be done. There are weekly monthly quarterly etc..) The supervisor would like to see this one report so he can report out to the mill manager.

thanks in advance,

Kelly

 

[PHV]

I get how to search for a specific month by using between dates
Any chance you could post your actual SQL code and expected result ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kdoran]

Sorry here is what I meant. This is from a prior db searching between dates on a form that shows the query

Between [Forms]![SearchfrmBeforeDate]![Text11] And [Forms]![SearchfrmBeforeDate]![Text22]

expected results would be for unbound text11 '01/01/2001' and text22 '0/02/2001' this would show all entries for that period.




and in sql

SELECT tblFieldNotes.FieldTagID, tblFieldNotes.FieldNotesText, tblFieldNotes.FiedNotesDate
FROM tblFieldNotes
WHERE (((tblFieldNotes.FiedNotesDate) Between [Forms]![SearchfrmBeforeDate]![Text11] And [Forms]![SearchfrmBeforeDate]![Text22]));

(FYI, I am not sql savvy)

thanks,

kel

 

[PHV]

Sorry, I don't see where the problem lies :-(
You want a GroupLevel in the report based on Format(tblFieldNotes.FiedNotesDate, 'yyyy-mm') ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kdoran]

Maybe this might help

Is there a way to run a query or thru vba for example to get data (date) based on a given time frame 1 month for each month and not have to put in the date field in a text box?