I'm trying to find occurrences of * in my data, but all I get is the wildcard
use. Is there any way around this? Thnaks in advance........bill

I have a very simple Totals query which counts the number of enquiries for
each customer, grouping by the customer field and counting the customerID
field.
I want to be able to give the count as a percentage of the total number of

I can't find documentation for new access db engine.
Any *.chm file (equiv to JETSQL40.CHM )?
I have found new ISAM drivers, but that's all ?
Thanks

I am using Allen's audit trail to keep a history of changes to my database.
Everything works great when updating from a form.  My problem is i have an
update query that is used to move a contact to another sales person.  My
query has 4 fields 1:Contact staus (updates to new lead) 2: ...

Hope someone here has a suggestion.  I have three columns in my table (Name,
Date, Number) and would like to update the Number field with a count of
records based on the Name and Date fields.  The Name field is sorted and the
count begins with the latest Date for that particular ...

UPDATE [Policy Infomation] INNER JOIN [Working Table] ON ([Policy
Infomation].TypeOfHaul = [Working Table].TypeOfHaul) AND ([Policy
Infomation].TypeOfPolicy = [Working Table].TypeOfPolicy) SET [Working
Table].Carrier = [Policy Information].Carrier;

The query below is used to populate a list box. Problem is the fields from
tblPMHlookUP; fldICD9code and fldTypeCode are comming up blank. This is
interesting as another field from tblPMHlookUP is showing up, that field is
fldDXDescription

HELP...this is slowly but surely driving me crazy!
The purpose of my query is to find out who has NOT had additional training.
(Additional training is its own table)
I have a query with 3 tables. All tables are joined by employee ID. Query

I wonder whether there is a difference between joining tables using the
Inner Join Clause or  the Where clause to join tables in terms of speed etc.
Thank you,
Samuel

Hope there will be somebody help me to create a crosstab query
with multiple Value fields.
I want a datasheet like below
Reject Item      Jan'07    Feb'07    Mar'07

I'm trying to calculate the corrected QT interval in a query, but I'm not
getting correct #s.
This is what I'm using;
QTc = [fldQT]/Sqr([fldRR])

Hi,
I need to be able to calculate the number of days that a bedspace was empty
in any given period. We currently calculate this taking the EndDate of the
periodand back counitng to the MovedOut date.  This does not however work

Hi all, i thought i would be able to achieve this alone and by searching the
posts on dates, but no.
I would like my query to return records completed in a specific month number
and by the current year.

I've seen in other posts that in order to have a query open in Pivot
Table view by default you can set the default view property in the
query properties.  Does anybody know a way to do this with a pass-
through query as there is no default view property listed in the query

I need to create a report from 5 different queries that have different amount
of fields.
qrMSM(field1, field2, field3, field4, field5, field6)
qrBfill(field1, field2)