I'm trying to create a database so we can track the miscellaneous shipments
that our office sends to the warehouse. I've got most of it set up (the
address, the tracking, the type of shipment) but I'm having trouble with the
last part of it.

I've got something like
SELECT (stop - start ) FROM table1; where stop and start are date/time
for example
I get:0,239583333333333    for start:7:15:00    stop13:00:00   

Hi All,  I have an access front end and a sql server backend application.
The tables were all working fine but now when I view a table in access it
does not let me add any information into them.  I have tables where the  pk
is an autonumber,  and the tables don't even have one blank ...

I have a table of club names which are grouped in zones. Each club
record includes the allocated zone.
I need a report which lists all clubs on zone one as a continuous
string of the names. (I hope that explains properly)

Help please - is it possible to give a warning on an unbound input form if a
required field is left blank in Access 2000
Thanks for any help

where do you find the 25 charachter product key on the certificate of
authenticity?

HELP!!!!
I'm designing a Database to record names of individuals and incidents they
have been involed in.  I want the primary key to consist of,  their LAST NAME
and 6 digits of their date of birth.

I am new to Access and I am trying make a Fee Schedule for work.  I have
been able to set up a form with the services, unit price, and list total.  
What I want to do is be able to enter quantity values for certain services,
and have only those services appear on a report (instead ...

I want to set up a command button on my switchboard (in access), that will go
to a word document. How do I do this?

Have an Access 2000 database which we use for members details. It has decided
not to work..get a message... this database is in a unexpected state and
"This database has been converted from a prior version of Microsoft Access
by using the DAO Compact Database method instead of the ...

Hi, I'm starting to use Access to organise the reports that we receive
from our resellers and I'm not too sure how to sort out the tables.  My
aim is to import data from the excel sheet that we receive into Access
(or maybe link to it?).  I'll receive a new report from about 20

Afternoon All,
Having a problem.  I have a database that I have created in Access 2002
using an english version.  It has been split and everything works fine.
All the other computers are access 2002 in spanish.  The problem I have is

I have created........
A table of contacts "tblContactDetails"
A Query "qryContactDetails"
A Query qryParameterSurname

Help please
I am working in Access 2002 and trying to copy the contents of text boxes
from one set of fields to another. The table is OrderHeader01 and the fields
I am trying to copy across are from ShipToAddress (1 -5) to BillToAddress (1

I'm creating a table one of whose fields has a lookup that includes 2 columns
from another table.  I need these two columns to display together in forms
based on the created table.  The table allows me to include two or more
columns with the lookup wizard but I'm unable to get ...