Thanks in advance for your assistance.
I am trying to create an IIF statement that will return Text AND a field
value. What I have input so far only returns the Text. Any suggestions?
Quote: IIf([Actual Quote] Is Null,"Due " & [Actual Quote],IIf([Actual

Sometimes I receive e-mails with attachments and when I try to open them a
microsoft window opens and asks me to enter my 25 figure product code, but my
product code only has 20 digits, so it does not work. I am left with dozens
of e-mail attachments that I cant open. I am ...

Hello Everyone! Using A02 on XP. I have a report to print bills for
statements mailed for calendar quarters between [StartDate] and [EndDate] and
a query creating fee records for each. I'd like to be able to allow the
person running the macro to be able to state what the ...

I have one large table with many clients information stored inside. I would
like to be able to filter through a query by drop-down lists to include which
clients and info I want included on the report.
Ideally, I would be able to "Select All", or have check box's that would

I am working with a multiple parameter search query.  The form I am
using to conduct the search displays the results in a subform.  I
have
gone through and really combed through the SQL to make sure there are

I have a report based on "customer" field and a parameter query.  How can I
set up the criteria for the parameter query so that if the user enters
"government", it will run a report that includes "federal government," "state
government,", etc.  or if they enter "state government" ...

I've got a query that simply displays the contents of an employee activity
table.
The fields are:
-Name

I have the following sub query in my query which is trying to calculate a
base based on two critieria within the same table that is used for the main
query.  
Base: (SELECT Small Busiiness Activity Detail.Spent FROM Small Business

The simple query below serves my purpose, but I would like to improve
upon it by having it prompt the user for the years.  In otherwords,
replace 2002 and 2006 with YEAR1 and YEAR2.
Thanks for the help.  I really appreciate it.

I am a little perplexed about the method for setting the default sort order
in a form. I have two forms in different databases that are almost identical
(one is an early backup of the other). In the backup version the sort is
working fine using the "order by" property. The same ...

I know you can only have up to 9 OR conditions in a query if you use the
grid, but if you type the OR conditions all on the criteria line, how many
can you have?

I am trying to see results in the following way:
                            Total Imp   1sided total   Two Sided total
Container ID  12345         10                       2                      
4

I have created an Access database (2003) that contains information about the
status of specific projects our office is working.  There is only one table
and the database contains the names of about 30 employees.  Each employee is
assigned specific work and required to input dates ...

I have a form with a button that when clicked I would like to have it go to a
file, get the number there, add one to it, and then save it back in that file
as well as display it in the field on the form.  I created a table for this
number, but don't know how to program the button ...

I have two tables that I join using a unique eleven digit key.  
Table A has the following attributes: name, address, city, state zip and
ext_zip. The ext_zip attribiute will always have 11 digits. Table B has the
same attributes as Table A in addition to others.