date function query

  • Thread starter Thread starter nerd
  • Start date Start date
N

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??!
 
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
 
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??!
.
Click to expand...
.
Click to expand...
 
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??!
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top