I want to rank records in query,found on microsoft support center and used it
like this:
Seniority: (Select Count(*) from Registery Where _ [score1] <
[Emp1].[score1]+1;)

i have 2 queries that share the fields "who" "when" and "amount".  One
reports the value of daily labour (time out - time in * hourly wage) for the
employee (who). While the other shows the amount paid on a particular date.  
When I create a query that includes these 2 queries and ...

I cannot seem to be able to get query fields onto a form.
I have two query's and neither one show up on the form design page for
available fields.
Don

Hello. I need to create a querie that analise a a specific value and compare
to some standards. Well, I was able to create this querie if the were no such
specifications.
Imagine that I have a value, i.e.: 1.50

I am trying to create a query that will find all activities in the database
that are not "Meeting" or "Loss of a loved one".  The following seems to work
except for the loss of loved one part. It still shows up.  What am I doing
wrong?  I have included the SQL in hopes that that ...

I am trying to reproduce a report I have had working for years in crystal
reports. The report required three instances of the same table to make it
work.
When I creat the query in report designe and run it the query works. But

I have a query that has several fields.  The fields range in type from
number to currency, to autonumber.
I would like to sum just one of the fields in this query.  Is that possible?
Thanks

I have two (rejected) checkboxes for approval.
If either one of these or both are checked then I would like it to show in
my query.
If they are not checked of course I don't want it to show in my query.

I have a combo box on a form that is used enter a parameter for a query. I
would like the user to have the option of either entering an acct # to
specify an account to query on or leaving the field blank and thus running
the query on all accounts. Below is the criteria field in ...

I have a customer orders table (Orders) which contains orders with and
without cost (Orders.Order_Cost).
I need a query to achieve the following logic:
Select all orders for a customer between start date and end date(including

I am trying to create a parameter query where the info to be looked up was
entered via a combo box (i.e. Month, Year).  Just a little insight:  I am
creating a year end report and put in a combo box for the month so that info
in that column will not be entered wrong and therefore ...

I have a table (tblDiscounts) which is a discount structure. Depending
on the situation, that table can have one or more records.
Structure:
Minimum   Maximum   Multiplier

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):

I've seen some posts regarding a similar problem to what I'm having but cant
find the resolutution!
I have a database with tableA which contains basic inventory info.  I have a
field in tableA named location.  There is a second table (tableB) which has

I have set up a query for 1 table.
The field I'm trying to run the query on is a text field.  I enter a name
(="smith, john") I get zero results.  However I have confirmed that this
user exists in the table.