First, thanks to all the folks that post questions and responses - I always
learn something new here.  Now its my turn - I've reviewed some of the
postings on OUTER JOIN but I'm not getting the syntax right. Here is my
example.  I have two tables of part numbers:

I have built a query that has a count function for a table.  On my
switchboard, the user clicks the button and the query pops up with the
results.  If a user enters records that would change the result of the query
how would I update the query so when the user clicks the query ...

I am wanting to create a report that will allow the user to select values of
<$x or >$x or =$x
If I use the criteria >50 in the query itself, it will return all donations
greater than $50, but if I use it as a parameter I get the following error

I have a table called Test. This table includes two fields called
"Start_Date_Name" and "Finish_Date_Name". These fields hold the
primary Id of a row in another table called Date_Properties, which has
a field called "Date_Name". Typical values for Date_Name include "Test

Has anyone successfully used an Access quety from VB.NET? I am trying to do
this and am getting a weird error. VB.NET calles queries 'stored procedures'.
The error I am getting says "Schema could not be retrieved for this stored
procedure' ... "The underlying enumerator did not ...

I'm trying to create a query that counts the number of orders recived hourly
for any given day, week, month or year. The end result is to try to track the
busiest hours of the day. Can someone help me with the easiest way to query
the database to return orders placed hourly?

I have a table which includes a field for Date of service, a field for Test
Code and a field for no. of services., and a second table which has these 3
fields , Test Code, Test Code name and unit price.
Depending on the date of service, unit price varies,  , eg Test Code M123

I'm using the results of a select query as the creteria for another query's
field. I am unable to edit any data for the second query's table.
If I use a make table query and use that table for the creteria, I'm
successfuly but have added another step.

I have a question about queries for Access 2003 database I created.  I want
to be able to search the queries for a large number of complex search terms.  
I want to make it easy for users to enter the correct spelling and syntax for
those terms.

my cursor is driving me nuts. it moves without a prompt from me and
initiates things without clicking. can anybody help?

            new user to access 2000 and i am trying to create a search
query that will allow me to enter in a value and return that value.  The part
i am having trouble with is i need to do this for many fields and if i use
the method i came up with, when i leave  a entry empty ...

Just a quick question, in the query design window, how can I update a list
of number to +1 from the final number in the list
TIA
Lez

I have a question that is quite perplexing.  I have 9 lines of
criteria that sorts retirees on a multitude of factors.  One group
that cannot be included in the section is where the [STATUS OF
COVERAGE-RETIREE] AND [STATUS OF COVERAGE-SPOUSE] are "CANCELLED".

I have a SQL query question...
I have a table with road segments that have a low and high address
(see sample QUERY below)
I am wanting to produce a report of the roads that meet the

This one is very detailed.  I am trying to run a query that gives me results
that contain the distribution center's name, the total number of parked
trailers there, and then the total cost that those trailers have accrued for
that destribution center.  The following is the Rates ...