Combining 2 numbers fields to create a date

[jfreds15]

I have two number fields (Invoice Month and Invoice Year). I would like to combine these two numbers in a new field to give me a full date so I can query on a range of dates rather than just query on one month of one year.

For example, if one record has a 3 and 2008, I would like a new field to read 03/01/2008. Is this possible?

 

[Rabbie]

Use DateSerial(InvoiceYear,InvoiceMonth,1) will give you a date Value for the 1st of the month that you can store in another field. Check Access Help for more info

 

[pbaldy]

Welcome to the site. Check out the DateSerial function in Help.

 

[jfreds15]

Thank you both for the quick responses. I figured there was a function, but wasn't aware of it. Will check out the help guide.

 

[MSAccessRookie]

I have two number fields (Invoice Month and Invoice Year). I would like to combine these two numbers in a new field to give me a full date so I can query on a range of dates rather than just query on one month of one year.

For example, if one record has a 3 and 2008, I would like a new field to read 03/01/2008. Is this possible?

Something like this might get you what you want:

=cdate(cstr(InvoiceMonth) & "/1/" & cstr(InvoiceYear));