I am attempting to build some type of database through Access that
will randomly take various dollar amounts from one column and match
them with a total dollar amount in another column.  I deal with
accounts that have dollar amounts that are returned to me in

I need to write either a query or VB to calculate daily interest on a
simple savings account.  I use the following formula(s) to calculate
the running balance for each transaction.
Transdate

I am attempting to append a string prefix to a report field which is
based on a query result.  I want the user to be able click a checkbox
on the form which opens the report to determine whether the string is
appended or not.  I see that this can be done in the properties of the

I am totally desperate because I cannot solve a really simple problem:
I have a specific text-file which I want to import into an existing
database. The problem is that the columns have different names so I
receive an error message when importing via the "Get External

I'm trying to clean up a large database in Access. I have one field for
address, which needs to be broken up into Street Number, Street Name, and
Street Label (St., Road, etc.)
The problem is that the data is very dirty. So some addresses will be

I'm a newbie to Access and am having trouble understanding the logic
behind queries. I have 2 tables, 1 for stock in and 1 for stock out. I
have joined these in a union query. the fields I have are:
Month

I have a text control on a form which is bound to table field StartDate
which is in Date format.  When updating the table record via the form, any
data entered into the StartDate control is immediately validated.  If the
data entered is considered valid, focus moves to the next ...

I have a form (frm_MAIN_RPT) that contains a combo box (Combo6) &
subform (dbo_REQ_subform).  The combo box is used to select the "cost
center" data that will be displayed in the subform.  From there, I
have a button that runs a report based on which item I select in the

I need to create a report or field that will show the difference between a
customer's balance on two different dates for every customer in our
database (for example, see below: I need the difference between customer
001's balance on 1/1/03 and their balance on 2/1/03). I have the ...

Hi
I want to email Invoice ID1 from a list of Invoices in a datasheet
My code for printing is
strDocName = "rptInvoice"

I have a macro that saves data to an A: drive.  If the drive is empty and I run
the macro, the drive clicks a few times, and a message comes up saying "the
file already exists, do I want to over write it.  I figure this is going to be
a neat trick, so I click yes with the drive ...

In our database, we have implemented auditing simply by holding a copy
of each row of the specific table at any time that data is updated. This
 gives us a long list of full records, often with only one change
between them.

Hi all you experts,
I have a 'small' problem
In a mdb I have a column called "PLACE"
its value type = text

I know this is simple, but I just can't seem to get there:
I need to sort a table by a text field (txtDescription), then assign
sequential numbers to the field SEQUENCE in table.
Every time a new record is added, the all SEQUENCE #'s must be reset.

Thank you once again for any and all assistance. I'm building an application
that's getting quite bulky due to the number of forms, macros and procedures. I
was wondering if there's a way to use 1 (one) unbound form, if all the fields
are the same for multiple forms populating them ...