IIf Function help with my Query

  • Thread starter Thread starter Suzanne
  • Start date Start date
S

Suzanne

First some background, I have two tables called 2007 Grid and 2008 Grid, in
these tables I have a field called Census Rec'd.
For my query, I need to create a field called Census Rec'd and I need this
field to do the following - If "Plan Year" ends in 2007 from "AFTAP Table"
then insert Census Rec'd from the 2007 Grid and/or if "Plan Year" ends in
2008 from AFTAP Table then insert Census Rec'd from the 2008 Grid.
Any suggestions?
 
I suggest you change your database design. Having a table for each year is
incorrect. You are starting to see the effects because of this problem. You
should have only one table and a date field that will identify which year the
record belongs to.
 
Unfortunately I cannot change the design of my database in that way because I
am not the only one using it, any other suggestions?
 
Back
Top