query issues

[9944pdx]

Good morning!



In my export query I have a [Date Field mm/dd/yyyy] but when i run the run the query that needs to be shown as an integer value.

Example: ID: [Date of issue]&"-"&[How many per day #]&"-"&[Tag #]
When I close the query and run the export will then look like this:

01/12/2011-1-2056 but I need it look like this 40555-1-2056.

I am soooooooooo very new at this. Any help would be great.

Regards,
pdx

[jzwp11]

Welcome to the forum!

You will have to convert the date to a long number rather than strictly an integer.

I think this is what you may be after:

clng([Date of issue]) & "-" & [How many per day #] & "-" & [Tag #]

[9944pdx]

Thank you so much...it works!!!!

[jzwp11]

You're welcome.