This SQL statement keeps saying that the Order By part can only use fields
from the first query.  I see the fields but perhaps something is missing?
Thanks
DS

I am trying to create a query that will show the records that have an install
date between the dates a user inputs. I have a contract table with a date
field called installDate when I tried a simple parameter query: The code I
put in the crieteria row is this ->>> Between [Enter ...

I've created a marketing database for a lawfirm.  I have a query based on my
MAIN table (containing contact names, addresses and attorney designation) and
a MAILING (containing areas of interest such as employment law, realestate,
etc.) table.  

This one is making my head hurt.  Any help will be much appreciated.
I have an online database that field reps use to enter new clients and
record client payments.  I have a batch file that downloads the data in an
.mdb file, and queries in another .mdb file that is linked to the ...

I have a table where i keep mission information.  i am trying to build a
query to pull the date (for date specific info), the type of aircraft, and
the number of inbound and outbound mission numbers.  I run a simple query
GROUPED BY date and type aircraft and COUNT both inbound ...

Hello,
MS Access 2003 on XP Pro.
I have a series of daisy chained queries to count Codes for me.
I have entries in MASTER that may have multiple comma separated codes in one

I need help in writing the following sql statement to retrieve data for the
last couple hours. My date field has date and time stamped in. Should be
something like "select from mytable * where DateTimeIn is between Now() and
Now()-2". Any idea?

So i need to create a query that gives me Quarterly position change for the
current year only, whatever the current year might be. and of course if we
aren't in that quarter yet it can just spit out zero. However, the computer
and i don't appear to be speaking the same language. ...

I have data coming from different sources. I would like to control the
formats when either using a Make Table query or an Append query. In some
sources, a column might be a number data type in another source it might be a
text data type.

Below is a simple Delete Query I am having problems with.  I want to delete
all records in Table: [SAART BTN'S WITHOUT TIECODE DETAIL] where field
[BTN10] matches field [BTN10] in Table: [Master List].  I get the Access
error msg below:

I've read all of the questions and answers on the use of a custom form to set
the criteria for a parameter query. I sounds simple but when I try to run my
query, I still get the standard dialog box and not the custom form that I
specify in my criteria. Please correct me if I'm ...

I have a Contacts table which holds some data I need to query. The fields I
need are Name, Phone, Extension, Email, Municipality, Facility, and Date. The
Municipality field has data in the following formats: City of...,
Municipality of..., Town of..., and Township of.... There ...

In my query, the table data for a group of products sums.  I set up my
database  years ago, and at that time changed the field names so that I would
NOT see fields like this:
SumAug-08

I am trying to create a query that is going to look at the last record that
was entered (this will hold the key piece of information).
I created a query based on Last for Date and Time, and provides me the
serial number that I want to use as criteria for another query.

My query is based on Returned materials. One number is issued for a return,
but can contain several parts. A quantity is assigned to each Return.
Occasionally a portion of the Return is shipped, leaving a lesser quantity. I
am using a running sum to calculate quantity remaining ...