Query by Month

G

Guest

The form frmEnterStartDate is set up so that the user selects a number from
1-12,which represents each month,example 1=Jan. I used this previously so
that I could create a report for 3 months. This time I only need 1 month at a
time. Do I need to change from [dteInput]) +3,1 to [dteInput]) 1,1)?
=DateSerial(Year([Forms]![frmEnterStartDate].[dteInput]),Month([Forms]![frmEnterStartDate].
Click to expand...
[dteInput]),1) And <DateSerial(Year([Forms]![frmEnterStartDate].
[dteInput]),Month([Forms]!
[frmEnterStartDate].[dteInput])+3,1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Previous Month Query 5
Query By Month and Year - Access 2007 2
Handle Blank User Input 3
Query by Month and Year (Repost) 2
Querry by Quarter 7
Query for previous week, Sun thru Sat, from date field 1
Year to Date subquery 3
End of Month: Parameter Query? 3

Top