Check for the Month only in a Date

[taimysho0]

Hi




table 1 has a column with request dates

table 2 has a column with due dates

a request date must be before the due date

im writing a query for the two tables, but how do i just check the month?

ex: if request date's month = 01/11/2012 in table 1, i want it to scroll through all the dates in table 2 where it finds a due date also in january. (there will not be multiple due dates in the same month)


can someone help with putting this in the Design View of the query screen

[orange]

A suggestion:

What exactly is your application? If you met a stranger and had to describe your database/application too him/her, what would you say in 5 lines or less?

Have you designed this application- laid out the entities and attributes, created tables etc?
The reason I ask is because you don't mention any of these things in your post. You refer to table 1 and table 2, and column with request dates...

It would help us help you, if you could provide a little more context. Even tell us what you have tried, what results you got ....

if request date's month = 01/11/2012 in table 1,

You may want to research the Month() function.

[taimysho0]

i see, was just trying to simplify the question

my app is designed for a user to request files from a third party

third party investigates site and reports back with information on the site.

user must get file in before a due date that is designated by a cycle day

my app also looks at the current date and the due date and does some math to figure out how many days the file is late (passed the due date).

the part i need help with is assigning the correct due date to the proper request date for that particular read cycle, data should all be in the same row


ex:
-->fields cycle request date due date
A 1/20/2012 1/23/2012<--this due date is grabbed from another table
A 2/19/2012 2/28/2012 <--query needs to know which due date to grab for same cycle
B 1/20/2012 1/8/2012 <---due date is different for each cycle even if in same month
does this make sense?

btw, i tried the Month() function in the query design view and it does not take it..Date() works but not Month()

[orange]

http://www.techonthenet.com/access/f...date/month.php

[taimysho0]

it looks like the month function works only if you choose a particular month, but how would i make it on going by itself? for ex: Date() always refers to the current day, and month

how would i refer to today's current month only? without changing the date value in Month (date value)?? thanks