Hello,
I am building an Append query and I am trying to add a way to have user added criteria to the query. I tried uploading a picture of the relationships I have, but had trouble uploading the picture, so I will try to describe it.
In a table called the "Building Table" I have the field "States", "Data Date" and then a couple of other fields holding data. In another table called "Regions", I have a list of the states as a field, and then another field called "Region", which puts the states each in a region (North, East, South, West). States is a primary key, and I have enforced referential integrity on the join between States in the Regions table and States in the Building Table.
I want to have a user input criteria where if they input "Yes" it appends the North and East data, and if they input "No" it inputs the South and West data.
Any ideas on how to do this?
I am building an Append query and I am trying to add a way to have user added criteria to the query. I tried uploading a picture of the relationships I have, but had trouble uploading the picture, so I will try to describe it.
In a table called the "Building Table" I have the field "States", "Data Date" and then a couple of other fields holding data. In another table called "Regions", I have a list of the states as a field, and then another field called "Region", which puts the states each in a region (North, East, South, West). States is a primary key, and I have enforced referential integrity on the join between States in the Regions table and States in the Building Table.
I want to have a user input criteria where if they input "Yes" it appends the North and East data, and if they input "No" it inputs the South and West data.
Any ideas on how to do this?