same day events

[BasiaT]

Hi,
I have dates in two separate columns:
column A all in format dd/mm/yyyy hh/mm/ss
column B data entered just as dd/mm/yyyy.
I want to find events happening on the same day. How can I make Access to disregard all data on hh/mm/ss?

Many thanks

 

[jdraw]

You should research the Day(), Month(), and Year() functions at
http://www.techonthenet.com/access/functions/index.php

Good luck.

Why do you record hh:nn:ss for column A?

 

[pr2-eugin]

Hello BasiaT, Welcome to AWF..

Have you looked at DateValue function?

 

[BasiaT]

Many thanks for the hints. I'll be trying to get rid of hh/mm/ss.

Answering jdraw: I didn't collect this data. I was given it to analyse.

Many thanks again

 

[pr2-eugin]

Glad you have it sorted..

 

[jdraw]

If the data is really a copy of some data, you could add a new field to the table a Date/Time field with ShortDate as the default format.
Then you can do your queries using this field, with no concerns for the hh:nn:ss.

When I get data for analysis, I usually copy the database to a machine for analysis and then leave the original database in tact. I would create queries or fields etc as necessary to facilitate the processing.

 

[reeseburg]

I would expect this is an import issue from a database that provides HH:MM:SS. I run into this all the time. It's easy to do in Excel using the Year(); Month(); and Day() functions.