The current method I use for matching mailing lists is a join via a created
"matchfield."  Such as this
Matchfield : Left([Last Name], 3) & Left([First Name], 3) & Left([Street
Address], 3) & [ZipCode]

I have to do a query and have a header and footer in it.  I know how to get
the header and footers in regular reports but I don't know how to do it in
query.  Please help.

Hello. I am using Access 2000 and I have a query with about 20 fields but
what I want to know is how do you go into a regular Select Query and change
it into a query or something that will give me totals for certain fields.
Could you give me in laymans terms what row headings and ...

Urgent problems that I need to sort before Monday, I will be so
grateful for ANY help received! I am not familiar with Microsoft Access
with Visual Basic, I only really practice basic C++.  I'm working on an
Access Application, and i have alot of repetitive variables for the

Dear Group,
I'm using SQL server 2000 with an Access 2003 application utiliting a
DAO/VBA based design.
I want to change my embedded, text based queries to queries in the

I am using this in a query...
Between [forms]![frmReports].[fldPeriodFrom] And
[forms]![frmReports].[fldPeriodTo]
but i really want to assign the two fields to variables and use the

I have multiple fields that I want to join to one field. For instance
ID  Name
1   sam
1   bill

I am using the following SQL statement which i found elsewhere on this site):

I have a query setup to make a new table and the table set up, I'm all good
there.
Here is my problem.  I need to convert a date from 11/22/1999 to 11221999 on
the new table, can't figure that one out.

Here's my situation:
I'm building an invoice database and am designing a form that allows
users to apply payments against invoices.
Because any one invoice may contain multiple items, I had to (?) insert

I am trying to put a restriction on the dates I have in a Union qry. I only
want to return records that are => the date I have listed in a form
"FrmEmployeeStatsDate.CBOStartDate" However I am not sure how to add it to
the code. Any ideas for me. Thank you

I have a list of people with events following the name, etc. with boxes in
each column for each event and i check the box if they have attended the
event.
i want to do a mailing with any of the people who have come to any of these

I hope Im posting in the right newsgroup.  I am trying to insert the
result
of the below SQL query in my Access 2003 table.  All the fields in this
table

I have 2 tables, networkveiw1 and computers. I also have a Query that
displays only the information that I want to insert into the computers table.
I need to take the results from that query and add that data into my existing
computer table, and I don't want to add duplicates.

I have a query that I want to parameterize so that I can display data
for any number of selected `Types` of components. My query (abridged)
looks like:
SELECT * FROM Subcomponents WHERE TypeID IN (55,56,58)