Query date

  • Thread starter Thread starter Simon
  • Start date Start 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
 
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.
 
DateSerial(YearField, MonthField, DayField)

Assuming all fields are integers.
Click to expand...

Month field is not an interger

month is like January Febuary ect
 
Simon said:
Month field is not an interger

month is like January Febuary ect
Click to expand...

Then you can do something like...

CDate(MonthField & "-" & DayField & "-" & YearField)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date search query 0
How to build a "reach around" query? 5
Extracting Month and year 1
adding records together 1
Query to list records that don't match 6
Access query 7
Using DateAdd and IIF conditions in a Query 2
concatenate text into a date 3

Back
Top