I am using Access 2000 and I have run into a few problems when I try to run a
report based off queries it asks me to enter the date range multiple times.  
Only one of the queries actually has a date range and the other uses that as
a source.  

ok - so I've got 6 fields on my form.  I want the user to be able to enter
information in as many or as few fields as he wants and then run a query
based only on the fields that have data in them.  If my math is correct there
are 63 different combinations available and I don't ...

I have a query that I use to generate a report.  I want to know if there is a
way to create an IIF statement to color code the lines in the report.
For example IIF (fld_SOPType)=BHQ, RED, BLUE)
Can someone help to let me know if this is at all possible?

9/1/2005
I am having difficulty opening a query recordset for analysis.
The following code opens the query with no problems when the query has
either no criteria or criteria specified as constants. When I attempt to put

I am trying to find matching names between two tables.  However, not all the
names are exact matches.  How do I get the matching names even if they are
not exact?

I have a query that contains both an Invoice Number and Line Number field. I
would like to display them Invoice Number Ascending meaning the first record
is Invoice number 1, the second is 2 etc.  I would like to sort the line
number the same.  The results of the query would thus ...

Good morning.
I am trying to add sql code to a query to determine if a field (Test01) is
null.  If it is not null then I want to add 1 to a counter (TotPts).  I will
then repeat the code for Test02...Test05.  I keep getting a "missing

I have a database with one table which is related to 5 other tables
ie. field productid in main table ties to product table with all details on
that product
question is how do i structure SQL code to return productname from product

I wil try to make this a brief as possible.  I am working on a database to
keep track of student information in an alternative school.  To do this I
have designed three tables that keep track of different information.  The
three tables are 1)General Student Information, 2)Student ...

       I am confused with how to tackle dynamic query/Report situation.
I Have a simple query which has some fields from tables and then some
calculate fields and a report based on this query has a criteria form to
filter records, but every time report will be run some fields ...

I have a large list of names in a database table which includes things like
account # and Date of Birth, Address, etc.
I want to run a query looking for possible duplicates.  I don't have the
duplicate query 'query selection' and so I'm needing to do it from scratch.

I have 2 queries, one to append data and the other to delete data, they both
use the same parameter (<=[Enter End Date]) I run a macro that combines the 2
functions in one step, how can I get this parameter to only show up one time
instead of twice?

I have a table that has a list of accounts I want excluded for a query.
Basically, I want this table to be updated by users with any accounts that
should not appear in the query as our information comes from other parties
that include all our accounts.

I have a query that is not updateable in either the query or form views. Any
assistance would be appreciated.
SELECT subtblClientPolicies.ClientPolicyID, subtblClientPolicies.ClientID,
subtblClientPolicies.PortfolioID, subtblClientPolicies.ProviderID,

Can someone point me to some docs or a white paper on the max size of an
Access DB before you should move to SQL?  I know that there is no "Hard"
number, but I need to know about the max size.
TIA,