date function query

[nerd]

hi guys. PLEASE HELP ME! i'm trying to show all records
appearing for the whole month. how do i use the date
function to show this??!

 

[kevin]

month(now()) gives you the current month.

If you have a query or form with a date field set the
criteria to month([yourdatefieldname]) = month(now())

Kevin

 

[nerd]

yeah thanks!- i found that one from the textbook and was
using that. it seems though that as soon as i add new
tables to the query it no longer works. any ideas??
thanks

-----Original Message-----
month(now()) gives you the current month.

If you have a query or form with a date field set the
criteria to month([yourdatefieldname]) = month(now())

Kevin

-----Original Message-----
hi guys. PLEASE HELP ME! i'm trying to show all records
appearing for the whole month. how do i use the date
function to show this??!
.

.

 

[Kevin]

If your queries are from multiple tables, you may wish to
double-check your table Relationships (linked fields).
The month(datefield) expression should be a
straightforward filter in the querie. Remeber that month
returs an Interger month (1-for January, 2 for February).

Can't think of anything else. Hope you get it working.

-----Original Message-----
yeah thanks!- i found that one from the textbook and was
using that. it seems though that as soon as i add new
tables to the query it no longer works. any ideas??
thanks

-----Original Message-----
month(now()) gives you the current month.

If you have a query or form with a date field set the
criteria to month([yourdatefieldname]) = month(now())

Kevin

-----Original Message-----
hi guys. PLEASE HELP ME! i'm trying to show all records
appearing for the whole month. how do i use the date
function to show this??!
.

.

.