I have a column in a Query that is giving me problems.
PRICE:
IIf([CDDiscountDP]=1,CCur([CDQuantity]*[CDDiscountAmount]),FormatPercent([CDDiscountPercent],2))
If CDDiscountDP =1 then the fiield is of a dollar amount otherwise its

I have been running this dB for over 2 years now without much issue, but for
some reason now I get a message box that reads "Invalid Operation" whenever I
run this query.  I can change it to and inner join and it works fine.  Is
there something someone might had switch in the ...

I have a table setup with the following structure
HoundID pk
JudgeID
TimeScore

 i want to update 4 different columns using just one query, at present i use
4 different queries one for each column which works fine.  however when i
tried to put them all in one update query it failed.
please help

1)  I need to be able to count the number of records returned by 2
queries (which I can do).
2)  Then I need to subtract one count from the other and return that
number.  Simple, right?  When I try to do this, I get the error 'Query

I need to put four tables together in a union query into one table: 07-09 A,
07-09 B, 07-09 C and 07-09 D. I'm not quite familier with the syntax of
unions. Please help. Thanks a bunch!!!

May I use query inside my union query or I must use table in my union query?
For example, my I use
select MyField from myQuery1
union

Hi..
I'm trying to get a query to show me all of the records with a specific
reference number, however I want to be able to choose them at random.
If I have 2000 records, each with a unique 'sub record' (with a unique

I am trying to generate a query that populates when a tick box called
Declined <28% is ticked. Those boxes that are not ticked are not to appear on
the query.
Can someone please help me???

I'm using the following format in a query criteria box to obtain user input
of a date via a form:
Between [Forms]![daterange]![start] And [Forms]![daterange]![end]
Form name and control names are definitely spelled correctly but all I get

Suppose you have an auxiliary table that looks like this:
IdWidget(Autonumber, primary key)
Widget (text)
Some other fields

based on helpful advice i found on here already, i created a union query so
that i could find maximum and minimum values (i hadn't heard of this type of
query before but the database was designed in such a way that a union query
was necessary)

I am getting error messages with my ASP below.  I don't have much experience
in this coding, so hopefully someone will be able to fix my code and get me
on my way.
Thanks,

I have the following query, qryCumulative
Week targetTotal actualTotal
1 3 3
2 5 nothing shown

I am beginning the construction of a minimal search via SQL involving three sets of search terms.
The three sets of search terms are each M2M with the main table (tblHeaders) through link tables.
I have SQL statements which return the hits on each set of search terms.
I am assuming ...