I would like to display percentages with the number of decimal places
required to do the job, up to a maximum of 2 decimal places. So that .55
would display as 55%, .055 would display as 5.5%, .0055 would display as .55%
and .00055 would display as .06%. Is there any way to make ...

This is a query that I use.  The problem is for time to time one or more of
the subqueries that I use will have a null value which causes the main query
to return null.  How do I make this work?
SELECT Table1.[Job Number], Table1.SetterCompany, Table1.[File Number]

I have query that shows all contracts, and links to the vendor table to
include the vendor name - we only have one "active" contract at a time per
vendor, which would be the one with the latest expiration date - so I want to
filter out old contracts - just show the ones with the ...

I have created a crosstab query to show orders by product by month, using
product name as my row heading and order date as my product heading and sum
of quantity of ordered as the value.
The problem I am having is I have attempted to format the order date to

I am using Office 2003 on Windows XP.
Does anyone know how to create a disconnected ADO recordset on the CurrentDB?
If so could you please post example code? (I would post what I have worked
on, but it doesn't work anyway...)

I have a query that extracts specific information out of my Diag2005 table.
The sql view is provided, and the resulting output. What I need to be able to
do is get a sum of PDX by PA, ie. I need to have the sum of PDX diagnoses
102+103 by PA (ASC-PA), sum of PDX diagnoses ...

I have a report based on a query which lists items stored in boxes numbered 1
to as high as 25.  The results are sorted by box number by item number.  Both
fields are alphanumeric.
For a query with 11 boxes, Access sorts the boxes as 1, 11, 2, 3, 4, 5, 6,

I work for a bank with 11 branches. I have two tables: (1) Retail Manager
Activities, and (2) Assistant Retail Manager Activities. Each table contains
multiple dollar amounts, such as Loan Portfolio, Deposit Portfolio, Past Due,
New Loans, etc. Each table has one entry for each ...

I know there is most likely a simple solution but i am just learning the
ropes with access and the whole VBA experience. I have a simple table with
Item and purchase number and purchase amount. then i set up a query recalling
all three to put into a report. I wanted to sum the ...

I want to write a SELECT query that will give me every fifth record.  I have
one on another issue that is a "SELECT TOP 15" and a basic "SELECT COUNT".  
What do I have to change in the wording to get every fifth record?
Thanks.

Hi;
Our mdb database has, among others, tblQuote & tblPurchased.
tblPurchased includes fields for City and Township.
tblQuote only has a City field and a checkmark control if the company qouted

I have a IIf function in a query field that reads like so:
OAR: IIf([Net Operating Income]<>0 And [Sale Price]<>0,[Net Operating
Income]/[Sale Price],"N/A")
[Note: I am learning about the Nz function, but right now this coding,

It's been awhile since I've done any Access queries and I need to calculate a
variance on actual sales  vs forcast sales for a week.  Below is what I've
tried.
SalesPerVar: IIf(([MForcastSales] And

I have a table with following field:
Respondent, Indicator1, Indicator2,.. IndicatorN, Country
I want to create a query to compare respondents from 1 country in one
indicator.

I currently I am using Access 97, and I have a Make table query that gets its
data from a table.  The table can only be edited through forms.  When I
create a new record in the table and then try to run the Make table query,
the query does not update, so any new records that I ...