between and date problem...Help

[pablavo]

hello, I really hope someone can help me here.

I have two dates fields - FundingFrom and FundingTo - on a report. I'm using both as criteria in an input form.

I want to use the Between, And function but I've only used this function on the one date field to filter the records.

does anyone know how to do this function on the Two fields so the between would be the "FundingFrom" and the AND would be the "FundingTo"?

If someone could help me on this part that would be excellent.

this part gets tricky. the two fields are short date 01/01/2000. I'm using the DateSerial Function to take the month and the Year to remove the Day part. This is so that a user can select only the month and the year from the input form. This is obviously with the Between,AND function with both dates.

If knowone can help on this part and only the first part, I'd still be able to work with that.

Thankyou for any help

 

[Fernando]

Use this to open your report from your form

DoCmd.OpenReport "YourReportName", acViewPreview, , "Founding >= #" & Me.FoundingFrom & "# AND Founding <= #" & Me.FoundingTo & "#"

Replace FoundingForm and FoundingTo for the text box name that you are using