Linking a form to a Query

  • Thread starter Thread starter Ozzie via AccessMonster.com
  • Start date Start date
O

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
 
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 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
Click to expand...
[quoted text clipped - 15 lines]
Many thanks
Click to expand...
Click to expand...
 
Back
Top