I am trying to set up a query in Frontpage Wizard custom query to return
field values in my
database based on current date base on year and month only using format of
mm/dd/yyy where dd will be a wild card value (I think?) have tried several

I have a course database where the table contains term, subject, courseno.  I
need the query criteria to be subject = ENG or FLR and courseno <500.  But I
also need subject to be WR and courseno >123.  Is there a way I can do this?

I've got a crosstab query performing counts on two items within a column. For
the sake of the example let's just say the values are "A" & "B".  Totals are
calculated by the number of occurrences of "A" & "B" for the previous day.  
Some days may have no occurrence of "A" or "B" ...

I have two queries. The first brings back 76,069 records and the second
brings back 4,954 records.  When i combine the two  in a union query I was
expecting them to bring back 81,023 which is the combined total but it brings
back 2,586.  We have a group of clients that get a ...

I apologize if I've used the wrong section.
I am working on a query that will calculate commissions for my salespeople.  
Instead of creating a long formula in the query to calculate the result (the
percentage of commission each salesperson earns is directly tied to the

Have 2 tables, tblA, tblB.  I need a query that selects all the records in
tblA that meet a set of criteria EXCEPT if there is a matching record in
tblB.
Query of tblA gives:

I'm trying to create a query that uses the same table to name two different
fields, and I don't want the second occurrence of that element to show up as
'Expr1004'.
Specifically, I'm using the same table to supply the title of the 'referred

What is the correct expression to get average handle time per return, rather
than per batch (returns are logged in batches that vary in quantity).
Currently using this espression to get AHT per batch-  Handle Time: [Sign In
Time]-[Sign Out Time]

I have a query with several fields and then a field that concatenates data
from some of them.  Is there a way to place a comma between them and only if
there is data?  I tried doing "," but that places a comma there regardless of
data and shows on report.

I've created two separate queries, as they pull different date ranges.
Problem is I want to combine the results of these two queries in a report.
When viewing the report I want all the information from both queries to read
left to right by customer.  I don't want anyone to scroll to ...

Does an append query need exclusive rights to the destination table to write
to it, or can the destination table be in use?

Is it possible to create cumulative numbers in a query
1) I would like a running total over all
2) I would like a running total over group
also I have a text refference field with 0123, 23198,  23, 348777 etc

I have the following Query:
SELECT IIf(Count(*) Is Null,0,Count(*)) AS [No longer in Facility]
FROM Residents
GROUP BY Residents.[Last Status Date]

Hi..I am a newbie....
I am trying to retrieve the second most recent date data from a query....Can
someone please help me.....
Here is the SQL for the most recent date info.....

I have a table with Dates, employees, job reference numbers and hours worked.
I am trying to run a query that shows a particulars job reference, which
employees that worked on that particular job, the date and the hours.
When I press run all it does is show where everyone was on ...