I have a table with 2 date fields: [Open Date] and [Close time].
Both field have the following format: dd-mm-yyyy hh:nn.
How can I calculate the difference in days between these 2 fields and how
can I display this on a report where I want to have 4 colums like:

I am new to this and I do not know too much about access I only want to use
to program if it can help me sort by contacts correctly! I tried using
address database but it doesnt allow me to have New York as the primary name
and the boroughs in different sub boxes!

Office 2003 on Windows XP:
I need to email Access reports to others in this office, so I installed the
Snapshot Viewer on the machines in this office.  On one machine, however, I
was prompted by Windows Installer for the original Office 2003 CDs.

How do I assign the vba code to a button on a form?
Thanks

I'm trying to put together a database to keep track of sales and customers. I
think I have the database itself laid out right, what I need to do is
generate reports showing sales by user. I think I have to set up a SQL
statnent for this. Each entry has three money fields. What I ...

I had overlapping data from one DB to another in a linked table.  I received
a suggestion to have all my tables in one DB (backend) and all my forms, etc.
in a separate DB (frontend).  I haven't done this yet, so I don't know, but
won't I have the same problems with overlapping ...

I am trying to learn MS Access 2003 and have trouble getting any help files
to work.  It keeps giving me the message
"Action canceled  Internet Explorer was unable to link to the Web page you
requested. The page might be temporarily unavailable."  

Is there a reason that I cannot click on a help topic and receive help.  It
keeps telling me
"Action canceled
Internet Explorer was unable to link to the Web page you requested. The page

I am mainly and probably only using access for my thousands of business
contacts and I wanted to know if this is the right program to use?

Hi! First, Thank you so much for reading this.
I am trying to build a pretty complex (to me anyway) database for work.
Ok, the problem is that I don't know that much about Access. I learn well by
playing with programs, though.

Hopefully I've explained this in enough detail.
Using Access 2007 on a XP machine I've linked to a database.
I refreshed the links and everything refreshes successfully.
I try to open the Db and I get a message that Index not found

After making an entry and moving to next line the data disappears from the
previous line.  I have to save and close database. When I reopen the data is
there.
Does anyone know why?  Also, sometimes the data entry is nothing but XXXXX's.

I wanted to create Desktop shortcuts that will open different forms in the
same Access database.  Currently I use the Startup options to open the
database to a default form.
Also, we currently use Office Pro 2003, but will be upgrading to 2007 in the

I need to find an Access database that keeps track of donor information for a
non-profit organization.  This would include name, address, etc.  Donation
amount, date, donated for ? and a place where I can keep notes.  I know
Access can do this but I have almost no experience on ...

I have multiple fields in a table. I need to move duplicate records(they have
same id number and dollar amount) into the update field 3/31/2008. Hoe do I
accomplish this? Thanks.
doument id     usd         usd as of 3/31