Create data in table

[IanT]

Hi
When I open a database, I would like to look at the current date, convert it to the month and update a table with the month only if it has not already been recorded. Is there a way of doing this!

 

[Rich]

Hi
When I open a database, I would like to look at the current date, convert it to the month and update a table with the month only if it has not already been recorded. Is there a way of doing this!

Why would you want to do this, what'sthe point?

 

[IanT]

point

Why would you want to do this, what'sthe point?

I want to build up month data in a table, to link to a combo, so it can be used in selecting criteria in a report. ie sales in January 2004.

 

[Mile-O]

What's wrong with taking the sensible approach and leaving the table as it is and using a query to populate your report?

 

[Rich]

Extract the Month from data that already exists in your main table as the data source for your combo