Select query generating new field?

[Jack Sheet]

Hi all, this may or may not be possible.

I have a table that contains fields YEM and YED containing integers.
YEM contains a nunber in the range 1 through 12 inclusive, representing a
month.
YED contains a number in the range 1 through 31, representing a day within
YEM

I want to do a Select query which generates a date, such as
DateSerial(2006, YEM, YED)
and display this as a new field in the query, called MyDate
The field MyDate does not exist anywhere in any table.

Any help is of course most gratefully received.

 

[Guest]

Hi Jack,

Not sure exactly what you want.....perhaps this?

SELECT DateSerial(2006, YEM, YED) AS MyDate FROM TableName


where TableName is the name of your table. Make the appropriate substitution.

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Jack Sheet]

That is exactly what I want. It was the "AS" bit that was new to me.
Thanks

 

[David F Cox]

in the design grid it is written as
mydate: DateSerial(2006, YEM, YED)

 

[Jack Sheet]

Thanks David
Appreciated

in the design grid it is written as
mydate: DateSerial(2006, YEM, YED)