Date parts in separate fields 1

[yont11]

I am completing analysis on a SQL database where the date for transactions is split between 3 fields. One field has year, one has month, one has day. I have linked into the SQL database using Access 2003. My question is how do I in an Access query join these three fields into one field to create a date that Access will acknowlege. I tried DateSerial to try and join the fields into one field, it did join them into what looks like a legitimate date. I then tried to use a criteria of >=01/07/07 in this date field but the query is not working, (it does not acknowledge the criteria).
Can anyone help? Thanks.

 

[PHV]

Replace this:
>=01/07/07
with this:
>=#2007-01-01#

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[yont11]

Thanks PHV, I will give it a try.