I am new to Access & trying to create a field that will calculate the
"balance due", by taking the "TotalTripCost" and subtracting all the
"PaymentAmount"s.  I can get it to subtract the first payment, but I can't
figure out how to make it account for additional payments (there ...

I have an output field in my db that lists  [SumOfBALANCE] however, when
performing a later function it turns out that if this field is blank I get a
blank result.  The fields won't sum a # field w/ a blank field.
How do I create an if  [SumOfBALANCE] = "blank", then  ...

is there a way to write in a text box more than one answer?

I have a need to have both A2000 and A2003 running on the same PC in order to
support my customers.  Are there any compatibility issues with running both
A2000 and A2003 on the same PC?  A2003 would be installed in a different
directory.

Hi all, Access 97
Nearly there.
I now have two tables T_Clients and T_Tasks containing autonumber primary
keys ID_Clients and ID_Tasks.

In the On current event of the parent form I tried the effect of typing
"me."
without the quotes, on a new line within the
Private Sub Form_Current()

I am having trouble with filtering a query.  I would like to do a "invoice
filter" like in the northwind sample database where it only prints one record
at a time.
i have orders that have several order details attached to them.  How can I

I am using =DatePart("yyyy", [OrderDate]) to pull through the month
displayed as mmmm format, from a field containing a date in ddd
d-mmm-yy format.  I am getting an error back - #Error.  Can anyone tell
me why?

I am an Access novice however, I am attempting to retrieve a value from a two
field product table. (Product & Price)  I have variable prodcut data placed
in a textbox by user button selections.  I had hoped to figure out how to use
that data to match the product field in a table ...

I am entering a number in a field that will be a multiple of .25 - the
number is automatically rounding itself up to the nearest 1 e.g. 0.75
becomes 1 - how can I stop this from happening?  Also, how can I set up
a validation rule to ensure that the number being entered is a ...

Getting error 3044.  Incorrect path to network drive.  How can i change the
path that access is trying to pull?  Sorry but I'm new at this and cant
figure this out.
Thanks

I have a querie with many different states.  I need to have it exclude two of
the states in the querie IE: AZ and MI.

I have looked for pocket access on my WinCE PDA (VX6600), and although there
are several "pocket" office products I can't find 'Pocket Access'.  
Supposedly its part of the OS.  How do I start it up, or if it isn't there,
how do I find a version I can install.  Everything I have ...

After setting up my "start up" options, I've noticed
that I can't get back to change those "start up" options.
The "Tools" menu is no-longer there.  I can't even
use "Ctrl+F11".  If I remember, I unchecked all the

I had set up a user level security with a couple of admins and a few users. I
did this setup on my system, the database is on the shared network drive.
When I opened the application in my system, it prompted and recorded the
Current User and passwords accurately. However, when I ...