Re: Membership database updates

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm guessing that when you receive your list, you don't know if the members
in your current table are also in the new list.
If you do have a way of identifying members (other than name and Date of
birth, which is never 100% reliable) like a unique membership number, we can
help you to make a query which sets a CurrentMember tickbox to True if the
member appears in your new list and all the other members in your Current
Table to False.
If you need to Archive your old records (because there are loads of names),
you can use an Append query to add all the 'False member's to an archive
table which will have a Year field so that you know which year they were
members. The False members will be deleted from your main table using a
simple delete query.
The Archive Table is created by copy/pasting your current table (without the
data).
Add a Year field to both tables to contain the year number.

This method means that you have the option to retrieve a member from the
Archive table and append him back if you still want his data and even use a
Union Query to unite the Archive and normal table so that you can view eg a
membership history of your charity.

You can now use your table without any name changes for reports and queries.
You can also copy and pasted of some of your reports and queries, changing
their name to eg QryArchiveMembers, RptArchivePayments adjusting the table
in the query grid to your Archive table and adjusting the Record Source of
the reports to point to these 'Archive' queries

The only alteration you will need to do to reports is to add a Year field
and group them by that.
Evi



"Pennington" <Pennington@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4CB0F97B-1E54-4378-BF79-B00287587F20@xxxxxxxxxxxxxxxx
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?



.

Relevant Pages

  • Re: Inconsistent MDX query performance
    ... Interestingly as I broke my query down bit by bit (basically I chopped the ... all of the RAM and brought the server down. ... Fortunately because my queries are generated programmatically it is fairly ... that have extreme numbers of members along one or more dimensions. ...
    (microsoft.public.sqlserver.olap)
  • Re: Membership database updates
    ... When you open any Query in Design View, click on the toolbar just next to ... black down-arrow where you can change your query to an Append or Update ... If you have any current members in your Import list, ... You mention Update Queries and Append Queries but I can't find how to ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Membership database updates
    ... I carry it as Text in this format: ... table I called Members Jan 08 but I receive updates every quarter and when I ... to Jan 08 to Mar 08 in the queries and reports several of them fail to work. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Syntax needed to get needed reports
    ... what you posted as a query will not work for you because you must ... I ran the update query below to see what happens. ... > UPDATE Members ... > WHERE [Hobbies] Is Not Null; ...
    (microsoft.public.access.gettingstarted)
  • Re: Membership database updates
    ... Add both your Current Table and your Imported table into the query grid. ... That gives you a list of all the members whose addresses are different in ... this can be done more quickly using a macro to run the queries ... You mention Update Queries and Append Queries but I can't find how to ...
    (microsoft.public.access.tablesdbdesign)