please see my query below.  I am fine until I enter the where Criteria
then I get the following message:
Invalid Bracketing of Name '[All Calculations.Dealer]'
SQL Is:

I have a form which comprises of a multi-select List Box bound to a table
and a sub-form bound to a query. When the user selects in the list box the
results of the query appear in the subform (very useful thanks Duane Hookom).
The problem that I have is that I need to be able to ...

I am using Access 2003.  I would like to print labels based on a query with
the results of one of the criteria shown in color while the other information
is in black.

Using aggregate functions in a query.  When I click the run button I get the
following message:  Cannot group on fields selected with'*'.  What do I need
to do?  The fields are not selected with '*' that I click?  Thanks

I have a parameter query that is fed by 3 combo boxes on a form.  the
combo boxes include an "all" selection.  there is a button to click to
run the query.  it works fine.  the problem is that after i run it i
have to close the results it gives before running another one.  I would

I want to create a query that pulls specific names out of a number of fields.
I have 10 fields labeled, Operator1,Operator2,etc.  
I created a query where I used the criteria, Between[Start Date] and [Stop
Date] to only select from a specified date range.  What criteria could I ...

I am a complete novice and I am trying to create a web site which will
require me having a data base collected from information based on matching up
post codes. Is it possible? do I need special software  or am I wasting my
time?

I have one table that track video conference meetings (among other things).  
In it I have a StartTime and an EndTime.  I want to calcuate the duration of
each meeting.  It seems pretty simple, but everything I have found is way to
in depth.

I need help with VBA.
I create a temp table to keep data for tranfering file from Excel. Sometimes
I have found unsorted data in the table, but always sorted.
All above I use VBA, so how can I sort data in the table? I need to use this

I am customizing the Issues Database Template (from the MS Template page)  
http://office.microsoft.com/en-us/templates/TC012186931033.aspx  to use with
projects.
I have two tables and a one form that I am working with. There are (2) two

I have a query with fields of Start Time and Stop Time and Total Time.  What
expression do I use to get the Total Time to calculate the time between Start
and Stop to get the total time?
Thanks!

I have two fields TIn and TOut. They both are Time Date values. I want to
calculate the diffence of these two fields and have the result diplayed in
hours worked. Thanks for your help.

I have a query that returns email and name based on other criteria
(Club Name).  It returns every record with a certain club name in it
regardless if it has an email not.  This makes it difficult when i run
the module to send it to outlook...the module fouls up.  how can i

I have a query that returns four columnes.  What I need is to have the
results in one columne. Not added(+) or concatanated(&). For instance
100 rows, four columnes: becomes 400 rows one columne.
Thanks

Any idea how to return 20 rows from a query?  I don't want to use ranking
(Top 20) as that doesn't properly address duplicate values.
Problem: I have a set of records with a score.  I just need the top 20
records.  Using "TOP 20" includes duplicates, and therefore, I get > 20