I would lilke to automate the update of tblRelatedItemsTable for our
B2B web (Books-Wholesale) there are only two fields ProdCode &
RelatedItem
All the needed info can be found by querying tblInventory the most

when i try to run compacting through macro it gives me an error. it tells me
do it manually. i added an additional command "CompactDatabase" into
QuitProgram macro. It is not working. Please help. THanks.

I have an address table, indexed by address_id.  Each user can have mulitple
addresses.
Assume "john doe" has address_id's 123, 456, and 789.  "789" being the most
current.  In addition "123" and "456".  

I am sorry if this has been answered but i just cannot get this to work.
I have a table named "email" on which I have a field named "subject".
There are 3 characrters at the begginning of every entry that I want gone.
Can someone please give me a step by step on how to do this.

I wish to performed some calculation if the condition meet.
If there is more than one iif statement to be include, how can i
combine together?
for example:

This is my query :
strQuery = "SELECT DISTINCT ID_emp,name,adres,city, " _
               & " sports = IIF(EXISTS(SELECT ID_sport FROM tblSports WHERE
ID_pers= tblArbCtr.persID), 1, 0)" _

I wonder why this code :
Private Sub Form_Click()
 Forms!Frmsearch!TBL7SF1.Requery
End Sub

I have a situation where a quote is generated based on a cost * quantity and
then multiplied by a margin. I have done this in a query.
The query is then the basis of a subform.
Now sometimes there is a need to either discount or  add a premium to the

I am trying to query for duplicate cheques numbers (where the currency of the
cheque is the same).   The following works when only a single currency is
involved.
Note the cheques are recorded in 2 tables [Cheques to Assignor] and Cheques

I am trying to convert some SQL Server queries to have them working with a
MS Access database and use ADO.
I am not able to find an Access equivalent for the SQL Server Construct :
ColumnName = CASE WHEN EXIST (.....) THEN 1 ELSE 0 END

The query I am using is to report information by "Year" and "Quarter" but I
have found that it reports by "Quarter" regardles of year. There fore I am
getting totals of quarters for the last several years.  How can it be
corrected to do as requested?

ACCESS 2003
I want to create list of all clients with date of last income change.  I am
getting only the client with last date rather than all clients.  Why?
SELECT tblClient_Income_History_DateV1.ClientID, qryClientNameV3.ClientName,

I run a Select Query called A that goes into a report.
I want to stop the datasheet from the query result appearing on the screen.
Can you help please

Let's say I have this table with 100 customers each with one
transaction per day. So the whole table with data for a month would be
100 * 30 = 3,000 records.
I have this query that basically returns how much each customer has

       I've created three tables for the sales of a company and now i'm
trying to run a query that only takes the sales after the month of january,
the expression Builder was no help Please Advise
                                                              Thanks