IIf (DLookUp("[MaxBlisters]","[tblProductSpecs]","[product]='" & [Data
]!Product & "'") <> and ([Blisters2])= Null) , True , False
Ok, first question is, can I put a formula like this in a query that runs a
report.  Second question is, does anyone see anything obviously wrong with ...

I have 2 tables; Orders, and Time. Each table is related by the "Invoice
Number" field. The "Time" table has several records with the same Invoice
Number. I need a query that, when ran, will show one record for each Invoice
Number, and a total of all the times.

I'm trying to utilize the dsum command in my query.  In this query the field
[Vendor Name] should come up with the same name.  However, there are several
dates which I want the dsum to be based upon.  The example below better
illustrates my intentions.

I am trying to create a Report based on a Query that prompts for a date
range. I need to display a chart of the daily averages of the dates with in
the prompted date range. How can I get the individual data for the dates in
the range?

          Sorry if the subject is confusing, doesn't make sense, or
just makes me look stupid. I've been learning Access on my own at work,
and I need to reproduce a functionality that we have in Excel...
          Basically, let's say you have a pricing estimation method

How do you get a unique record out of a query? My query contains multiple
records, but I only want to filter out the unique ones.

I've redesigned a database, making significant changes to the data structure.
The old database contains just one table; whereas the new one has 7 tables.  
I basically created a new one from scratch, and will soon be importing the
data from the old one into the new one.  

I need to set up a query where part of the WHERE clause is an IN(list)
construct.  The list will consist of one or more values (up to 3 or 4)
selected by the user.  I therefore would like the "list" part to be a
parameter to the query, so I can plug in the set of values before I run

Each year I need to create a report from raw data extracted from another
program.
The report will contain a single line of text with a field for the total at
the end of the text.

Access 97.  Summary query.  Field value is 0 or 1 and have StDev in the total
line.  Within a group, if there is only one record I am not getting a value
for standard deviation.  Works fine as long as there is more than one record
within the group.  I could probably manipulate a ...

I have a count query that i am using to measure the registrations on a
course (for each course). All works well except i need the query to return a
0 value when there is nobody registered. At the moment the query omits the
courses with nobody is registered and without anybody ...

I am currently trying to design a query which brings data out of three
tables. I want it to show a list of all the records in Table A and then ones
that match those in table B and table C. However, I also want to show those
that dont appear in either so that i have a total number ...

This is the query I have
"List all students, by name and number, who took more than 2 modules in
semester 1 of 2000"
I need to know how do you determine if a student as done 2 or more

I have one table "IN" which has selected records that need to be added to a
second table "BOL Control".
The "BOL Control" has a sequential/indexed field [BOL #].
Is there a process to add the records from "IN" to the "BOL Control" with

I was given great help recently regarding updating of a field with a static
number.  I was wondering ... if I needed to populate a field in a table with
an incrementing number - is this possible?
Example 1:   Name     Dept Code