I'm not sure what I'm missing but I have a query set up with the following
fields and prompts underneath each.  Everything worked great.  Report opens
with information shown and calculated.  Now, boss wants to see all jobs
regardless of vendor or model and I can't get the query ...

Running queries from a form is very good! I learned it from the Access
Tips!!!!
We can run query by using a list on the combo box on the form.
---------------------------------------------------------------

I am having a little issue with queries.  I have 2 queries. Query A has the
fields [Tote Number], [Part Number], and[Unit Qty], and Query B has the
fields [Tote Number], [Part Number], and [Qty Picked].  Query A by it self
has 298 records and Query B has 305 records, but when I ...

Please excuse this question as I am a newbie.
I have a query with 20 columns. First four are part number and details. The
other 16 are just activities that store week numbers.
I need to search on the 16 number fields and if the criteria matches the

I have to put together a report/query that calculates a number of different
counts.
Is there a way to put together an expression like:
Count(IsNull([SalesInstructionIssued]) AND [SalesInstructionIssued]<Date())

How do I count the number of unique records in a field within Access?

How do I make a query that numbers each record in a separate field?
Even better - numbers the records in the child table - i.e. every time the
parent table has a new record, the sequence in the child-records starts from
1 again.

The query below is expected to return 'distinct' fields from a text field.  
Does distinct work within MS Access 2003 databases?  Any ideas?
SQL
SELECT DISTINCT [Sales by Customer (Cube)].CompanyName,[Sales by Customer

Sorry im a newbie.
I have a simple table that has data with a week number.
how do i get a form to ask for a week number, then input that week number
into the query to show the results in a report?

I ran a query based on two tables and joined them with 2 meaning match what
is in table one with what is in table two.  One column from the first table
appeared but data from the second table came back blank, all rows matched,
but the actual data did not.  Anyi deas?

I have 2 queries I wish to combine, one contains weekly hourly employee
payroll (WHEP) data and the other weekly salary payroll (WSP) data.  I do
not know how to combine or link them so that when I enter a specific date,
both the WHEP and WSP data are listed into a single query.  ...

I have a table called classes in there I have a few fields called “day 1 day
2” and so on, in there I type “Y”, that means that they came that day and
then I have a field called “total days attended” how can I make that it
should count all the days attended ?

My users need line item information contained in a report to be contained on
a single line for every Order Number.  They don't like the grouping function
which does essentially the same thing, but in the interest of keeping the
peace I've been trying to use the fConcatChild ...

Ok, so here's the deal. We have 5 teams that work here and some customers
overlap depending on the required product. Team 1 can have Customer 1 because
he orders Product Type 1 but Team 2 can have the  same customer because he
also orders Product Type 2. So, I am trying to ...

I Am having trouble with a Query. I want to use an "orderdate" in a combobox
to select dates for reports.
Here is what the query looks like: "SELECT DISTINCT
tblNewTransfer.[OrderDate] FROM tblNewTransfer ORDER BY