Hello i need help
i have found this cod to send email message to members and it works fine.
is there an easy way to change the cod so i can have the members first name
put in the Body of email, ex if i send email to nick.name@hotmail.com and his

Sorry about the generic subject. Hard to sum this one up.
I am trying to design a query that displays multiple customers
products. Each product has a sell price, however in some cases a
separate table (PriceException) will have an entry that indicates a

I was doing a query and when i ran it, it prompt me "No current record is
found" and 2 of the 11 fields show error. When i add in 2 more field (Which
is the 2 error field), all query work fine and all the records shows.
Do anyone know what actually happens?

 I am having a bit of trouble here...  I have 3 queries that are Identical
with a few exceptions but the design is the same... Each looks like this:
qryDayPart1
SELECT tblSales.SalesDate, Sum([Sales]/100) AS DayPart1,

I have a table of diagnoses where one field contains the specimen ID. It is
an ODBC linked table to SQL Server.
There may be more than one records for a specimen, where one record is
supposed to have a Boolean field called Final is set to True.

Let me start off by saying that i'm a real rookie with access. Ok now
that I got that out of the way - I am trying to create a criteria that
references 2 different tables with the same field. Both tables have
the field named PLNTCODE and I would like to run a criteria that says

When I use  InStrRev([Canvasser]," ") I get the results below --
Canvasser        InStr    InStrRev
Andrew Box Bill    7    11
Tristan Brown    8    8

i have a problem.
i have a query where i want to have to possible criteria for one field and i
need the query to choose what criteria it should use.
here is the sql as it currently is:

I am trying to run a query where I am looking at data in a customer table and
looking for matching records in a vendor table basing that match on the
vendor/customer name. I have some records where I may have a partial match
(ABC Company vs ABC Company, Inc.). If there are ...

I have an corsstab query that counts the number of tasks created each day.  
Currently I have it set to give me a daily count for the most current 7 days
which gives me 5 columns (workdays).  However if we happen to have a holiday
in there then we only see 4 columns.  I'm ...

I have this query which counts all the claims for each member but I
want the total number of claims  so I can double check the number of
records submitted is right.  How do I get the total count?tnx
SELECT [2007_SUBMISSION_HISTORY].MembID,

I´ll try to explain my problem:
Table: Parts
          IdPart, MyDate, IdCategory, Hours
Making:

I am trying to set up a summary query to identify how many total days a
patient has gone without any medication. The following are the data that I
start with.
Member #                Fill Date    Days Supply    Next Med Date

I would like to achieve this without writing VB if possible.  I have a form
(FORM1) and two queries (QUERY1, QUERY2).
FORM1 has two Text Boxes (TB_START_DATE, TB_END_DATE) and a Button (RUN), a
user retrieves formatted records within a particular date range by entering

I am having a problem with my database going into a total lock down after I
run an append query (qryAppendTests). It's sort of like the program is
freezing, but it is not freezing, It is just locking up.
I have read some other threads about using a UNION to append records from