View Single Post
  #2  
Old March 19th, 2008, 02:36 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Membership database updates

Why not just name your table "tblMembers" or "Members" without storing any
data values in the table name?
--
Duane Hookom
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?