Help with query based on Date

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi All,

I am trying to write a query that will pull back records of products
recieved on a given date. The table has been set up so that when a product
is recieved in it puts in the Date and Time, so how do I write the query so
that it will look at the date portion and ignore the time portion? I can not
change the table properties.
Also this recordset pulls back the dollar figure for each recieved product
and after pulling all of the records for the given Date I would like to have
it sum the Dollar column and give me a grand total. I have not been able to
figure out how to make this happen either.

Thanks for the help,

Jeff
 
Hi,


WHERE DateValue( MyDateAndTimeField ) = [Some Date Without Time]



Hoping it may help,
Vanderghast, Access MVP
 
That helped! Thanks
Michel Walsh said:
Hi,


WHERE DateValue( MyDateAndTimeField ) = [Some Date Without Time]



Hoping it may help,
Vanderghast, Access MVP



Jeff said:
Hi All,

I am trying to write a query that will pull back records of products
recieved on a given date. The table has been set up so that when a product
is recieved in it puts in the Date and Time, so how do I write the query so
that it will look at the date portion and ignore the time portion? I can not
change the table properties.
Also this recordset pulls back the dollar figure for each recieved product
and after pulling all of the records for the given Date I would like to have
it sum the Dollar column and give me a grand total. I have not been
Click to expand...
able
to
figure out how to make this happen either.

Thanks for the help,

Jeff
Click to expand...
Click to expand...
 
Back
Top