Search results

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

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