I have two tables, one with member details and one with comments joined by
memberid (autonumber). I have a csv file that loads new records onto the
system and I need to append to the member table, and add a comment linked to
that new record to say we have received the new member.

Hi, I have a table as following:
Name             Date of Service
MMM              01/05/05
MMM              02/12/05

Hi. I have a table [qry_all] with the format show:
    [Date]    [DrBalCur]    [DrBalODu]    [DrBalRes]    [DrBalTot]    [PrDt]
    28-Oct-05    1,002.00    29,379.66    753.83    31,135.48    27-Oct-05
    29-Oct-05    1,949.07    29,379.66    322.79    31,651.53    28-Oct-05

Need Help!
I am trying to locate the Clip Art files in Office XP so that I can select
some to enhance some of the forms and reports in my Access database. How do
I find them? I could use some help, I have tried the help menus but to no

I am trying to write a query that will prompt the user for a date then match
the entered date to one of three dates in a table and then return the date
and other info from a table. I initialy wrote a Switch query as follows-  
Date:Switch([Enter Date]=[Date1],[Date1],[Enter ...

It's actually Excel/MS query, but it's the same query engine -
Query tries to calculate data from two tables:
table1.sales / table2.units as UnitPrice
table2.units is 0 sometimes which causes a divide by 0 error and query

I have a query that uses a combo box for the result.  Or at least it is
supposed to.  I have the code: forms!myForm!comboname as my constant in my
query.
Then when I select my info from my combo box on the form then click my

In managing an organization i have a "Members" table linked to a
"MemberLedger" table.  the members table stores contact info, etc... in the
ledger table, each record is a trasaction against each members' account:date,
description, charge,payment,  etc.  i want to keep a running ...

I have a pivot table that shows the aging of files.  I run a report every
week to get new figures.  I have a count of all the records and a field
showing the age of the file.  As time goes by, records move from one aging
period to the next (eg. 0 - 15 days, 16 - 30 days).  I ...

I need to assign sequence numbers in multiples of 10 to a BOM file that I am
creating.  I have the following information in a current table:
ITEM         COMPONENT      QTY         SEQ
1               XXXXX               1            

I have a list table of names and address: tbl_DATA
I would like to create a query to return the top 5 CITIES with the most
records.
Also I would like to create a report and output the total number of

right now I have [What Game] in the criteria field in a query and this give
me the ability to select a game.  also when I run a report that uses this
query it prompts me for "What Game" and then it generates the report.
My challenge is this:  I want to choose the game from a drop ...

Create a query that accepts user input for a minimum Selling Price and
maximum Selling Price and selects all books within that range (including max
& min values). There should be 2 separate prompts for users. Include the
following fields . . .blah blah

I'm still a bit new to programming... I have a main form with employee data
[Employees] and a subform [Reviews] with data entered by year and quarter.
Somehow, I'd like the user to open the main form and select what year and
quarter's data should be displayed in the subform. The ...

I don't know Access jargin too well, so i'll try to explain this as
clearly as possible.  I have a main table which contains the names of
all of the family members involved in a research project I work on.
Each family member has their own record.  The table is keyed by an ID