I’m using a db to track investments. Simplified, there are two tables with a
one to many relationship
Fields included in the first table, tblPrime are:
InvID  (primary key)

Ok I am really frustrated but here goes.
I have a Macro which I have managed to read a select list of records based
on a query.  Simple:  Read a record, change the values of 2 fields (boolean);
one to YES and one to NO.  No biggie!  The problem is that the macro runs

I have imported files from an excel spreedsheet into a new database in an
attempt merge some fields. In previous years this data was provided to me
with patient data being on "one" row with certain fields that have different
dates being denoted with the test perfomed and the ...

I have a query where each record is a merchandise order.  Columns include
"ModelNo." and "#Units" (and order date, PO#, etc). I want to make another
column called "Total Units" where, for any given record, it will return the
total number of units ordered for the same MODEL as the ...

I am very new to Access and would really appreciate some help with this....
I have an Update Query:
(both SentLetter and over2yrs fields are in test3 table)
UPDATE test3 SET test3.SentLetter = IIf([over2yrs]<=Format(Now(),"mm/dd/yyyy")

I have a query which generates MatchNumber, based on values in the table
(thanks to Karl Dewey in an earlier post in this forum).
SELECT T.Player, T.MatchDate, T.Position, (SELECT COUNT(*)
     FROM Stats T1

I am modifying the Orders Management template provided by the Microsoft
template site.  It's perfect so far, but I have run into a major problem.  My
costs vary on a day-to-day basis and I want to be able to update my master
costs list daily without it affecting orders submitted ...

I'm trying to search data in the IWDateN field and pull out only the data
between the dates 12/1/06 and 12/31/06. If the date is what I want, I want
the row data put in the output, otherwise I don't want the row data.
I keep getting a Data Type Mismatch error.

There is no logical criteria to select employees for a project (from Table of
employees).  The manager basically uses intuition and personal info.
Using a Form;  manager would like to scan/scroll down employee list and
"pick" employees to be on project....i.e. be their records ...

Is there any way to remove formatting symbols like parentheses, forward
slashes and dashes from contact phone and fax nos?  I believe this would be
best done by query.  Are there any knowledge base articles on this subject?  
This seem like it would be a common question.

I have a table that has eight fields of the 'Yes/No' datatype.  Is it
possible to calculate the of 'Yes' entries for each record?

Please help me how to write Ranking in SQL
Code    Date          Price
220-00    20-Oct-06          25.25%
220-01    20-Oct-06          23.72%

After downloading contact info from the Internet into Outlook, I then export
the contacts into Access.  Sometimes the original data does not have area
codes (10 digit numbers, only 7 digit numbers).  Outlook automatically
inserts the home area code that is in the dialing and ...

Attempting to create a prefix for the ID, I first set up an ID field with
Autonumber as the datatype.  This gave a number for all of my contact
entries.  I then saved the table, then changed the data type back to text.  
The next thing I did was an update query putting the desired ...

I have an Access 2002 database.  I created a number of queries in it to
query against the database server.  However, everytime the code calls the
query, it prompts me to enter the password.  My code looks like:
Set rs = db.OpenRecordset("myquery")