I have set up the following query:
SELECT [qry Totals to Date].ID, [qry Totals to Date].Date, [qry Totals to
Date].Supplier, [qry Totals to Date].Reference, [qry Totals to Date].Gross,
[qry Totals to Date].Sample

I want to generate a report but filter out some records, depending on the
value of a certain field. From what I can gather reading the posts in the
Reports section, I need to do it from a Query but have no idea how.
This field simply has 1 character in it... and A, B or C etc.

I have this database structure:
GroupNumber  GN End Range    GroupName    CustServInd
7404            Don and Deb Lawyer          A
7405            Don and Deb Lawyer          A

What I want to do is this : when I enter a number in a form field I want it
to automatically double its value?  Is this possible and how.

I have a query that returns a variety of student psychometric data (IQ,
reading level, etc). There are about 12 different fields that contain this
data.
I want to design an interface (switchboard, I suppose) so that staff can

No need to respond unless you are from Microsoft.
I'm not sure why the screen to offer suggestions to Microsoft took me to a
discussion group, but here goes in case anyone from Microsoft is monitoring
this.

I need help...I have a column in my query with five different names separate
with commas(,)...how can I extract one of those specific names? I thank you
in advanced for the help.

Using access 2000
I have a Main  table
I have a Player Stats table
I have a Player Info table

I have in a table the saved absences of persons. So:
name, BeginAbs, EndAbs
John, 1.5.2005, 12.5.2005
To get the absences for a certain date I use this query:

When I enter percentages it shows like this
I enter 4
it appears 400.00%
I want it to show 4% or even 4.00%

I have a long time field, however for my calculations to work in later fields
I need it to round down from seconds.  I have a time for 12:04:29, the field
will only show "12:04", but I want it to permanently be "12:04" so that
calculations later to value 0:00 instead of 0:00:29.  ...

I have been doing a report called OpeningOrders where I do a Max by
transaction date and obtain the first time that someone purchased from us.  I
then do a date a date restrictor and get everyone who has purchased from us
for the first time in the last 30 days.  I am now trying ...

I need to find a way to replicate what Excel does with the Find function.
Any help will be very much appreciated
Aron

Is there any keywords other that DISTINCT and DISTINCTROW that I can use to
stop duplicate records from being printed in a mailing list. DISTINCT is used
when only one field is needed from a record. I tried to use it, but I got an
error because I need for than one field in the ...

We have a template Access Database with all relationships created.  Queries
are running off of these relationships.  The data is being imported weekly
from other Access and Oracle Databases.  
Since upgrading to Office 2003, after importing the tables, the