If you have a column in a query that has a lookup combobox specified, and you
try to add or change the name of that column in the result set (not the value
or expression for the column), the select statement specified for the lookup
combobox is lost.  

I have created a continues form, based on a query. In the header, there are
some comboboxes that gives the user the possibility to make certain
selections. Everytime a selection is made on a combobox, there is a VBA
action: ME.REQUERY. That works very fine: the user sees always the ...

How do I calc the number of distinct values in a field.
Doing the following returns the distinct records (which in my case is 247).
I actually want to return just the number of these distinct records, i.e. 247)
Rgds,

I need to separate items into
sales clusters that are defined by ranking all the items sales and
determining which ones compose the top 70% of total sales, the next 20, and
the last 10.  So in pseudo code terms you need to rank the items from highest

All,
I have an Access 2000 database at work that contains quality control data
for written reports which are released to our customers.  It's a flat
table with columns like:

I need to have a query pull just the information prior to the previous year.  
This query will be used to pull information for a report that will be run
every year.

I have a query that pulls records with various status dates.  Some have dates
in a Completed field, some have dates in a Referred field, some have dates in
a Closed field and some have not been processed so they have no dates (Nulls)
in any of the fields.  I need to sort the ...

I have a crosstab query I want to create a report from.  I understand I need
to create column headings which would be Investigator, combinedtotal, Total
Of case_num, and 4 or 5 columns for week ending dates depending on how many
are in the month which come from the ...

Is it possible to edit a query using the "On Click" event?
I have a form that displays a list of avaiable reports.  One report has a
sub-report in it that has a query as the data source.  When selected the
reports criteria needs to set based on the individual's record, so I need ...

When I run a query, I need to be prompted to enter 2 different strings.
The field is 'Status' and I need to have it return all data containing 2
different strings. For example, records where 'status' contains "Microsoft"
and "6".

I am getting a "Division by zero error" in my pass-through query.
Here is my Select statement
SELECT
CD_CODE,(SUM(HP_SYSTEM_EXPECTED_BOOKINGS)/SUM(TOTAL_NET_BOOKINGS))*100 AS

Item Reference: "Date " & [Document Date] & "  Amount $" & [Outstanding
Balance]
I have the above expression to populate a field in a table using an append
query.  My problem is that the [Document Date] field is coming through in

I'm very new to Access (trying to teach myself) and have several Committees
within an organization with the same person(s) being a member of more than
one committee and with a different title (function) in each committee.  I've
created a table for each committee but not sure if ...

Despite MS Access limitations, users should still be able to create queries
to meet all their query needs. Thus there is no need for users to feel that
they can't ascertain certain information.  True or False?
I ask this question, because i feel that i'm very limited due to

Okay, I'm missing something. I have an if statement on a field (negative
partials), properties is set to currency on both fields(partial mrc) and
(negative partials):
Statement: