I am trying to produce a query so simple, I'm almost embarrassed to ask this
question!  I have two tables: (i) Projects, which lists a number of projects
for student assignments, and (ii) Students, which lists the students and the
projects they're to conduct.  Students are ...

I'm trying to write a query something like this: "Sum(Pcs)as Pcs1 where
Date <=[Begin Date], Sum(Pcs)as Pcs2 where Date<=[Begin Date]-1" so
that both Sums appear in One result record.
I have the Select part working as a UNION query, but I don't know how

I tried many unmatch query but not have result. Please help.
I have 2 tables: Score1 and Score2, 2 table have identical structure.
Score1: ScoreID, Name, Q1
Score2: ScoreID,Name,Q2

I am trying to create a query but can't get the criteria set up correctly...
I'd like to run a query for our patients who have been charged code (X or Y)
AND ((A) or B or C or D)
So I want patients who have X or Y and A along with codes that support A...

I would like to know if it is possible to "explode" a table via a query;
here is a small example
Table fields
ID    number

I am parsing a text field from a table ( ex Data: A/ASEL)
I reviewed the MVPS.org/Access webpage to get a start.
Here is the function the parsed the field correctly:
Test:Right(Mid([FieldName],Instr([FieldName],"/")),Len([FieldName])-2)

I have designed the tables for the information that I need several times,
trying to find the right way to set up the data so I can get a Querie to do
what I want it to do and summerize the data for me.  I have to enter in
simple client data, tie that to plan data that will change ...

Im trying to get the prevous YTD to work. The current year to date
works fine.
Projects: Sum(IIf([StartDate] Between
[Forms]![frmRptDateRange/Note].[BeginDate]

After docmd.openQuery opens a select query, what is the syntax to close it?
Actually I don't need to see the result of it. Is there a way to make it not
show?
Set qdf = db.QueryDefs("qryInvoice")

I would like to be able to set a Column in one of my queries that will give
me the abs(max() of a series of columns within the query .. I am having
trouble.. I can seem to get the query to do anything except either add or sub
the columns with in the query....

Hey guys, maybe it is a silly question, but I don't know that much of ACCESS...
How can I append data to a Table checking if the new data is already in the
table?
I mean, I want to avoid duplicated data based on only some fields, not all

I am running a query in Acess that produces a null field for a few of the
results (this is intentional.)  How do I run another query to change the null
field to a value of 91.  I have the formula as this:  
Quality: IIf(([Percent])=Null,91,([Percent]))

I've already spent a good 3 hours or more reading posts and help topics and
trying everything I can think of to solve this.  What I am trying to
accomplish is to graph DaysOld for 8 different backlogs.  I have 8 queries to
accomplish the backlog reports and that is all fine.  I ...

Hi, help on this would be much appreciated....
I have a database very similar to the northwind example i.e. supplier
product, customer, order etc....
I have set up a form with a sub form for customer orders exactly a

I have three tables
Provider info
Provider Monthly Info
Months