Membership database updates
Duane is correct. Having multiple tables with the same data is never a good
idea. You are already seeing the side effects.
If you need to separate the data by quarter (can't imagine why), you can add
a field to your table that defines the Year and Quarter. I have such a field
in a table in one of my apps. I carry it as Text in this format: yyyyq (for
first quarter 2008 it would be 20081. I use an input mask and format of
@@@@-@
--
Dave Hargis, Microsoft Access MVP
"Pennington" wrote:
I have created a membership database for our local branch of a charity and
designed various queries and reports to analyze particular trends. The source
table I called Members Jan 08 but I receive updates every quarter and when I
import the new membership list naming it Members Mar 08 and change references
to Jan 08 to Mar 08 in the queries and reports several of them fail to work.
I have had to recreate the queries and reports all over again.
I don't want to have to do this every quarter so is there an easier way of
doing this like running a find/replace query?
|