My output is a report that calculates currency for different events (Mission,
Bibleband, offering, brohood, sishood, etc) and then adds the total of all
the events based on members who paid.  I have a query that pulls members that
paid based a on a YES/NO field, a query that then ...

Using Access 2000:
Trying to update one field from one tale to another table. The update would
effect 167,956 records. When I run the update I get "not enought disk space
or memory to undo the changes". I have 1 gig of ram. Any suggestions?

I have an SQL statement that I am trying to get working but am having some
problems
This is the statement I am trying to use
strSQL = "SELECT tblMain.* " & _

Hi all, I'm having quite an issue trying to get a query working and was
hoping someone here could help out.
I am querying a table which holds a date field (refdate) by allowing the
user to select the month from a combobox named rptdate which is populated

My parameter query works fine. The query asks for the user to input data to
search for and then it finds it. What I need is for the query to loop and ask
me again without me having to exit and re-enter the query to input again. Can
anyone help me?

Ok, I have 2 queries qryTardyToady and qryTeacherCount.  I need 1 query to
join both of these in a particular way.
I have a combobox, cboTardySelecton, a form, frmTardyUpdate, that needs to
be populated.  The population is the join of these 2 queries.  The only kids

I have a selection query combining a few different queries.  What I
need to do is write a query that takes this information and returns two
collumns(fields) from this query that a user selects to create the
results for a report.  Here is what I am trying to do.

I'm working in an Access Database. I'm constructing a Line Tendence Graphic
with records  from a Crosstab Query (CTQ) and this one from Costs Table and
Count of Incidents Table. The columns of the CTQ show Months of a year due to
criteria "Between Initial date and Final date" of ...

I’m constructing a Line Tendency Graphic in a Database of Access 2000, from a
Crosstab Query with Columns showing Months of a year and File showing Costs
($) of the desired months with “between Initial and Final Date” criteria
(Chort format). The problem is, the Line Tendency of ...

I am using an linked table, i create an query from the linked table. In my
programming i get an error saying "Operation must use an updateable query". I
found it strange it worked perfect for the first time or second time, it did
sent the data. and then after this popup message ...

We have revolving contracts with vendors that roll-over into a new contract
with a new cont# - I want a query that only shows one contract record per
vendor, based on which record has the latest contract end date.
I think DMAX just give the latest record based on the criteria

.When i try to access Outlook Expres to check email.  A pop up box comes us
(Windows Script Host) saying "Cannot find script file "C:/Program
Files/SBC/Connection Manager/sprt/htmlagent/vbs/tsoe.vbs".  when I close this
box by clicking ok button and press the Send and Receive ...

I am using Access 2002 and I am trying to find all the duplicate policy
numbers in the Policy Number field in one particular table.  My question is
how do I get the duplicate policy number to show in the query.  For example
I may have policy # AB101, policy # AB101, policy # ...

I have created a query that is supposed to update a field (current period) to
a value based on the current date and the (Day span) field which contains
non-zero values. The problem is that all results are zero.
UPDATE [Task frequencies] SET [Task frequencies].[Current period] =

i have a table named customers which holds all my customer info.
I have a query which calculates the customerID from the customers last name
and first name. CustomerID: [Customers]![Last Name] & ", " &
[Customers]![First Name]