I'm getting a type mismatch error.  I want to update the check box [Indicator]
to "0" in [MasterTbl] based on the criteria.  Thanks for your help in advance
Dim strSQL As String
Dim varitem As Variant

What would be the best way to make 50 query updates run right after each
other without having to do it manually? Also to query appends? Code or
macro??
Thanks!

I have a date field in my record.  How do I write my query to limit my
returns to only records where the date is in the current month?

i have created a form with search options. it allows the user to search the
databases, each search option e.g. "Find Customer" the customer will click on
the button and a box will appear asking the user to enter the Customer
Account Number. if the number exsists the databases ...

I have a table that acts as a log for data contained in a separate
table.  I need to retrieve the last entered date, location, and status
for each different record in the main table from the log table.
Fields in the log table (aka tblLog):

I am trying to show a list of our stores that open in either 2007 or 2008
without using Criteria. Can anyone help me? I am posting the query I would
like to use.
SELECT tblStores.StoreNo, tblStores.StoreName, tblStores.[Store Open Date]

I'm working in Access for the first time in many years.
I have a number of joins created between various tables in the Relationship
window.
I created a query that uses a number of these tables.  The previously defined

SQL
SELECT E164src.MonthID, E164src.LiveMonth, E164src.Total AS [Current month],
(SELECT monthID from E164src AS temp WHERE temp.monthID=E164src.monthID-1) AS
Expr1

I would like to configurable top records in my query.
Does MS Access 2003 support dlookup in the query for select top query?
For example
Select top Dlookup("[MyNumberField]", "MyTable", "[MyId] = 1") MyField1,

I have created a query which compares the utility meter readings to a
previous average. The query identifies where variances are in excess
of 30%. The problem I have is that I am attempting to use an update
query to insert the text 'excessive variance' in a comments field

I want to create a query that shows elapsed time from the previous record and
I'm having a lot of difficulties....
The fields I have are
User ID, Case#, Units, Location, Date/Time

Greetings to everyone!
My situation is this, my database creates a work order with some tasks, that
may or may not be accomplished. I have a query that retrieves the tasks
present on a selected work order, (those tasks come from a table called

I have the below code in a Pass through query that pulls from a Oracle DB.  
It is pulling data from 2002 through today.  It takes 13 minutes to run and I
really only need data where the KTMG_TIME_SHEET_LINE_DETAILS.ACTUAL_DATE is
equal to or greater than 12/31/2008.  If I can get ...

I need some help designing a qry. I have an employee table. Each employee is
trained to a certin level. Each level requires some addtional creditentials.
In another table I have those creditentials link my the employee ID. I need a
qry that tells me if an employee trained to ...

 I have a table tblSales that has the following fields: DateID (Auto),
SalesDate, SalesTime, SalesAmount.
I am trying to create a query that sums all the sales for a specific date.  
Add all the salesamounts per a salesdate.  When I try this I get a sum query