Hello Group.
I have imported an excel spread sheet into access.
they hyper links work fine in excel but do not work once I import them into
access.

New at this. I am having trouble writing my formula (invalid syntex) to
get sum of one field if another field is ="credit"
=Sum([Total_Paid])IIf([MoneyRec]="Credit",0)))
And then I Need to another formula to subtract $700 from the sum for a

I have an Access database for 8 users.  Only one user is
having trouble opening a report and the other users are
not.  I'm using a command button to execute the report
and the error is "Run-time error '2501'; The OpenReport

I am new to Access and have designed a database by the seat of my
pants.
I have a problem with a database I designed. For each record (called
Product) I am trying to add several fields together (call them Qty1,

I have inherited an Access DB and I have been trying to clean up extra
Qureies and replace with DCount.
I have been fairly successful but.......
I want to comine 2 that I am using and make them the inverse .  One is

Is there a utility available that will compare the properties of two Access
2000 forms?
I want to see where the properties differ between the two forms.

I find it frustarting that every time I go into calendar, I keep on having to
re-tick the shared calenders boxes. I would prefer it if it were possible to
keep others calenders open as a default
----------------

I have a Report and I need to count data based on information contained
in other fields.  For example, I need to count all the ID Numbers where
the completion status is 100% and the invoice amount is greater than 0.
I need to put this expression into a text box but I have come up ...

I have had this problem for sometime now and not sure how to clear it.  I
have been debugging code and now it works fine.  I clear the break points and
run the code but the code still stops at an old (CLEARED not flagged) break
pioint.  

Occasionally my forms maximise them selves.
To stop this happening should I use popup, dialogue, modal or set resize to
no.

What I mean is can I have a Form/Subform that has a Listbox /Combo Box above
each field and do searches on the main db and return relevant data that can
be viewed and edited below the relevent Listbox/Combo box

I used a database wizard (Contact Management) to create a new database.  I
then created a new form in my database and added a new item on the
switchboard to link to this form.  When I view the form from the Database
window, I can view the records entered onto the form.  However, ...

I used the access to make an address database. I would like to know run
mailing labels from this. I have tried mail merge with no success. What am I
doing wrong. I have 256 addresses in the database
Thanks

I am new to Access programming and I am needing to find out how create a
query to get information on patient accounts that are in arrears : 30 days,
60 days and 90 days past due.
Hope it makes sense.

I have a bound form and one of my text boxes is pointing to a a date/time
field.  Whenever this value goes in the time is appended.  I have set the
format to = shortdate and added the correct input mask. I am seting the
value on the textbox to = date. and the time is appended.  When ...