Query date

S

Simon

I have a query that is based on a table with day, month ,year all
split up in different fields

Is there a way in the query to create a date field with all joining
all 3 fields together


Thanks

SImon
 
R

Rick Brandt

Simon said:
I have a query that is based on a table with day, month ,year all
split up in different fields

Is there a way in the query to create a date field with all joining
all 3 fields together


Thanks

SImon
Click to expand...

DateSerial(YearField, MonthField, DayField)

Assuming all fields are integers.
 
I

i_takeuti

Simon said:
I have a query that is based on a table with day, month ,year all
split up in different fields

Is there a way in the query to create a date field with all joining
all 3 fields together


Thanks

SImon
Click to expand...
 
Top