Creating Field Names in a query

[Gringarlow]

Hi again, I am hoping to create a field name in a query that will change every month. Right now the filed name is qryTechQuintileMonth-7.am_quintile. this designates that the data is for October 2012. There are 6 other fields named similarly for Nov 2012 through April 2013.
Is there a way to name these fields with the proper month-year (mmm-yy) so they automatically update each month?

 

[boblarson]

Hi again, I am hoping to create a field name in a query that will change every month. Right now the filed name is qryTechQuintileMonth-7.am_quintile. this designates that the data is for October 2012. There are 6 other fields named similarly for Nov 2012 through April 2013.
Is there a way to name these fields with the proper month-year (mmm-yy) so they automatically update each month?

You would need to build the SQL in VBA to do this. Do you want to go there? If so, I'll post code to do it.

 

[Gringarlow]

Ok, i'll read up on Normalizing. Thanks

 

[Gringarlow]

You would need to build the SQL in VBA to do this. Do you want to go there? If so, I'll post code to do it.

Yes, I would appreciate that. Thanks