Field parse

[Marky]

How to split a field in an Access table where the Date and Time are included? ie dd/mm/yyyy hh:mm::ss AM/PM, split to 1.date 2 Time 3 AM/PM.
The solution would be perfect if in conjunction with a query using this field.
Thanks for any help.

 

[John Big Booty]

Have a look at the Format(with Dates) function This will do what you are after.

 

[Marky]

Hi John,
Thanks for your swift reply. I have tried SQL as per but minor error msgs. I'll let you know when it works. Cheers from a Higgs boson.

 

[Marky]

Hi John, thanks for the link. Found the answer, g'day and cheers, mate.