I have created a parameter query, and specified criteria in an Auto Number
field (which is also the primary key) and when i run the query i get no
results.  Why?

I have a matrix of checkboxes on a continuous form.
I would also like to use checkboxes in the header to specify parameter
criteria in the form's query. The rows that appear on the form should match
the criteria checkbox contents. If the box is (triple state) grey, the

Hi, I'm having problems running a make table query from an linked table in
access 2003 (via ODBC connection)
I can view the data as a query but when I try to use make table query it
gets as far as letting me know that the existing table that i want to make

I have a table that I import from another access database.  It has field in
it that include Name, ID, Weekly Target etc.  That is a person in the table
that appears twice but has two different IDs.  For instance, the person's
name is Joe Smith who has an ID of JS1 and JS2.  What ...

I have this line of code working.
Form2 Form_load
   currentdb.QueryDefs("qryPassthrough").SQL = "Exec INV_getParentItemBYID
" & Me.OpenArgs

I have a query (main query) whose data comes from one table and one query
(data query). In the main query I have criteria such as Forms!frm1!Field1 so
it only retrieves data for the contents of Field1.  The problem is the data
query needs to be filtered the same way but when I ...

I have 4 separate tables of which all have fields "Surname", "Forename" and
"DOB", plus the data column.
Tbl_0 = S | F | DOB (this is all 5 users)
Tbl_1 = S | F | DOB | Data1

SQL Srv2000 and Production Database - what I want to do is open the live
database, keep the data and save it to be manipulated in a
"non-connected" manner (so that I have NO effect on the real database)
and keep that newly manipulated (need to remove certain fields in order

I have a query something like this. I want to order it by total. Everything else works OK
only ordering doesn't work. It displays me window - 'Enter Parameter Value'. If I enter
something, it displays it again, and so four times. And it DOESN'T order by total anyway.
I have tried ...

Each month I create a new table using the SQL below, where the records are
just copied from the GoalsMain table, except that the NewDate changes each
month.  This works great unless I've added a new record in the
RecordLocatorMain table.  What I need to happen is for that new ...

Thank you to everyone out there who has tried to help me over the past few
days. I am having a hard time getting my mind around this problem.  The SQL
at the bottom is as close as I can get. The tables listed below contain data
on employee performance; each row contains a date ...

I need to compute the median not an average.
Using help in Access 2000 it says there is a worksheet function "median".
No there is not. It says undefined function when I try to use it.
I have found the help in access 2000 to be totally worthless. It gives me

I'm querying a table that has payments recorded in [payments] and the next
payment due date recorded in [duedate]. Only the most recent payment row has
a due date recorded, [duedate] is empty in the other payment rows. (there's
probably a better way to do this but i'm new).

I need a spreadsheet to generate 5 days before the anniversary date of when
the contract was issued.
Example
I have an Issue_Date of 10/10/2002 and I want to be notified this year on

I have a form that is based on a Query. Since I have based the form on the
query I can no longer enter information on my form. I am stumped. How can I
base a form on a query and still be able to enter info on my table?
rebecca&payh.org