I'm using Excel to bring back info held in an access DB - I need the
user to be able to define any one of about 4 parameters to bring back
data. I have been using MS-Query, but it won't let me use Nz (so if a
parameter is left blank, it looks for blanks grr)...

A couple of months ago I posted a question on how to filter a query with many
criteria. I did get a helpful answer, but I have got myself in another pickle
and cannot get the suggested code to work. In addition, I have simplified the
database by having fewer linked tables etc.

I have a table called 'tblAppeal1' with various fields in but there are two
fields I wish to total on a report. Firstly, I would like to count how many
records per 'User', Secondly, how many are still 'Active' or 'Closed, and
finally, what percentage of the total (Active) they have. ...

I have a query in which I included a sum of two fields and called it "Total"
I then wish to take the field "Total" and and divide it by another field to
get a percentage. When I run the query it brings the created filed up like a
parameter what do i do to prevent this from ...

I am extracting some information from my database in week format.
I have done this in the normal way of using the Format function and W.
The week number it gives me is one ahead of actual week number in my diary.
Has anyone else come across this, or know how to fix it??

Hi, I'm trying to do a query that will look at today's date =date() and
compare with a date stored in a table and pull out if they are within 30 days
of each other - either before or after!  Is that possible?  I can get the no
of days calculated and the difference in days ...

I want to use Time as criteria to Acess queries. Problem is if the data in my
table contains hrs not minutes (10:00 AM) then my query is working fine. But
the data contains time say 10:30 AM/PM & if i use 10:30Am/Pm as criteria,
then my query is not retriving any records contain. ...

I have the following query:
SELECT Orders.OrderNumber, Orders.[Customer Name], Orders.[Order Date],
Order_Details.[Item Number], Order_Details.[Item Type],
Order_Details.Description, Order_Details.Type_Colour_Size,

I have a form (Mileage) that tracks my mileage using two fields (From and
To).   I have a table (Distances) that lists the mileage between all possible
From's and To's.  I have created a query that pulls the current values in the
From and To fields of my form (Mileage) to locate ...

Sorry posted this in Forms by mistake:
I found this great app developed by Duane Hookom and incoroporated it into a
small app I developed for our family. Everything works great except that if
there is a Hyperlink field and you export the query results to Excel, the

Access 2003: I'm trying to create a query that will display two different
types of numbers from a table. I have a tbl with numbers and a tbl with
number type they have a one-many relationship. How can I get the query to
display two different types of numbers (Type A & Type B) for ...

I have a table with one field (text) "EXP1"
The field contains this type of data:
22 minutes
117 minutes

I am having a problem when I hit duplicate values. The running sum does not
change. Can I add 1 or .01 or anything to prevent duplicates from happening?
SELECT DISTINCT [ABC Cycle Preview].extcost AS ExtStdCost, Sum([ABC Cycle
Preview].extcost) AS SumOfExtCost, ...

Hello.....
Access 2003 ...Windows XP Pro  
In maintaining my record position within a recordset, to use after a
Requery, I am using the following code which is doing the job.    

In access, I need to run a query that will give me a concatenate of certain
fields IF the same order number number shows up more than once (if the order
# shows up twice then I need Access to concat both rows, 3 times, then concat
all 3, etc).  Example: