Linking a form to a Query

[Ozzie via AccessMonster.com]

I have created a User form whereby users select a current period number and
year. The results of their selection is then placed into a table called
"Current Period".

however, and hence my problem,

my table that I need to link the chosen month/year to has each month as an
individual field. They are not under one field.

ie finance table = [mth1]; [mth2]; [mth3] etc.

current period table = [current Mth]; [Year]

how can I build a query using the two tables to give the answers selected in
the current period table??

If you could give any answer in idiots guide that would be great!!,

Many thanks

 

[aeronaut]

You may have to normalize you Finance table so that there is only 1 month
field. I am not sure what '1' means in 'month1', but that may have to put
these numbers into another field.

 

[Ozzie via AccessMonster.com]

I can't do that as I link directly to the system for my data, and the column
with the monthly numbers comes though as one column which I then have to use
SafeSplit to breakout each number!

If anyone has any idea how to do the query I am after I would be most gratful,


Cheers all,

You may have to normalize you Finance table so that there is only 1 month
field. I am not sure what '1' means in 'month1', but that may have to put
these numbers into another field.

I have created a User form whereby users select a current period number and
year. The results of their selection is then placed into a table called

[quoted text clipped - 15 lines]

Many thanks