Date and Time Field as One Field

[bpk]

Can someone help me to put the date and time field as one so that it shows as DD/MM/YY HH:NN in one field. I have the date and Time in two fields currently.

thanks a lot

 

[Brianwarnock]

[datefield] & " " & [timefield]

You can wrap Format round that if the fields are not alreadt formatted to your satisfaction.

Brian

 

[neileg]

If your data is stored as date/time datatypes then you may be able to simply sum them. Access stores dates as integers and times as decimal fractions so date and time together is simply the sum of the two values. So:
[datefield] + [timefield]

 

[Brianwarnock]

Oh bu&&£r! why didn't I thing of that.

Brian

 

[bpk]

I tried both your suggestions in a query, doesnt give any result, am i doing something stupid ?

 

[neileg]

I tried both your suggestions in a query, doesnt give any result, am i doing something stupid ?

Don't know. You haven't given us a lot of information!

What are the datatypes of your fields? Can you post the sql of the queries you have tried?