Could someone tell me whether this is possible? I'm very new to Access, and everything I've tried has not worked.
I'm going to try to describe the scenario as well as I can:
I have a database which divides several different locations into regions (e.g. "Atlanta" in region Southeast, "Charlotte" in region Carolina). The database includes both the specific location and its region in each record.
What I'm trying to do is to get the specific location to act as if it's in another region without changing the original record so that I can cross-tab and count it as belonging to a different region. (For example, get "Charlotte" data to act as if it's in the neighboring region "Southeast" instead of its home region "Carolina".) I'm essentially simulating a redistricting project, but I can't change the region it's actually in right now in the record, or else the current data will be compromised. I also can't copy a table in which I can alter the data, as the data will be continuously updated, and the "redistricting" needs to work for future use.
Is there a way to do this? Or will I have to essentially do the count "by hand" once I have the location data? I don't mind if I have to do it "by hand," but my supervisor anticipates having to do this again, so I was asked to see if there was a way to do it through Access.
I'm going to try to describe the scenario as well as I can:
I have a database which divides several different locations into regions (e.g. "Atlanta" in region Southeast, "Charlotte" in region Carolina). The database includes both the specific location and its region in each record.
What I'm trying to do is to get the specific location to act as if it's in another region without changing the original record so that I can cross-tab and count it as belonging to a different region. (For example, get "Charlotte" data to act as if it's in the neighboring region "Southeast" instead of its home region "Carolina".) I'm essentially simulating a redistricting project, but I can't change the region it's actually in right now in the record, or else the current data will be compromised. I also can't copy a table in which I can alter the data, as the data will be continuously updated, and the "redistricting" needs to work for future use.
Is there a way to do this? Or will I have to essentially do the count "by hand" once I have the location data? I don't mind if I have to do it "by hand," but my supervisor anticipates having to do this again, so I was asked to see if there was a way to do it through Access.
