convert dates to numeric values

  • Thread starter Thread starter jnew
  • Start date Start date
J

jnew

Greetings,

How can I display dates as numeric values in query results?

I need to UNION two tables. Each has an ID field (primary
key--auto number) and a date field. Here is my problem:
Due to a lack of foresight, each table may end up with
duplicated IDs. To uniquely identify a row in the UNION
query, I'd like to add the ID and date, but the result
appears as a date. I would like it to appear as the serial
number.

Any help will be greatly appreciated.

jn
 
To force a date to a number you can use one of the conversion functions.

ID + CDbl(DateField)

Depending on your data you could end up with duplicates. Why not just use both
fields in the select statement?
 
Back
Top