I want to add a lot of e-mail addresses to a membership database.
The database has 2 relevant tables
Home details
with fields:-  GroupID: various Address fields: E-mail

The field contains verbiage such as this;
"Cust. needs P136547896, 635216, 209157."
or
"Could no find assembly number, kit is 456789."

I need to do a Dlookup and have looked at all the examples and can't seem to
get mine to work on a form.
Form Name:   CC2 Eval Info Form
Table to do Lookup:  CustomerLoyalty

I am running a query on a dues billing which has quarterly payment dates.  
However, some will pay annually, some semi-annually, and some quarterly.  
These are the pertinent fields:
[Member No] [January] [April] [July] [October]

Hi, I can really use some help here...
I am working on a database for the risk management department that tracks
"Incident Reports" - including details of the incident, category of incident,
date & time, branch where it happened, etc.

Hi. I need to create a query that chooses me a column based on a criteria.
Imagine. I have a form and in that form I a have a field with text.
So, in my query I choose a table with as many columns/fiels one of the
columns and many of them as the name that will appear on the text ...

I have data table like following
Emp No   Activity Date A1Value  A2Value   A3Value   A4Value
1             3/20/2008       10         15           10           15
1             3/21/2008         5         10            1              2

I am making a comparison with 3 numbers in many records
Nr1 is a static number
Nr 2 and 3 are variabel.
I would like to get the number that is the closed by Nr1.

I have a query which prompts for a date range.  I would like to be able to
save the user's response and use the range in the title of a report.  Is this
possible?

Hi Access Wizards,
I have been using the Unique Values property in the query design window. The
only problem is that it uses all the fields to create one unique result. What
I need help in is to run the query using the unique values property to filter

I trying to create a query with this criteria:
[forms]![64_form_YTD_YTG_Printings]![Combo77]!column(1) and it's not
working. It also retrieves me the folowing information: Undefined Function
What's wrong?

I have a database for rentals, with an arrival date field and a departure
date field. It is easy to count the days between one and the other.
The question is, if an arrival date is Feb 23 and Departure March 15, from
the 20 days difference, I just want to count the days stayed ...

I have several queries that have worked fine for years yet everyonce in a
while they absolutely will not run. They are "make table" Queries and I will
get the message that I about to create a new table...It will chug and chug
and chug...one or two dots on the progress indicator ...

I an appneding records to an Access table from an Excel file where the data
in the Zip Code column is not consistent; some is numeric while others are
text.  The corresponding field in Access is defined as a text field.  My
problem is that tthe resulting records have a null value ...

I am trying to create a update qry that if the value in tbl ITEM is null
update from table SUB on Field Description. So far I have..
Field: Description
Table: SUB