I am trying to develop a db to track people that go to conferences, where,
when, how much etc. I have three tables, one called employees, one called
events and one called funding centres. I have tried to form relationships
between tables and I think this is where the problems ...

I would like to build an Access database for multiple users to enter and
retrieve data in a Form. They will not only enter data, but after each entry
run a set of macros that will update and populate fields in a table.  The
database will be on a shared drive, but does Access ...

Please help me to create a multivalued lookup column. I'm currently making a
movie database. This is for Movie genre. A one movie could have number of
genres.... and I want put them in a multivalued lookup column. I need step by
step...

I'm trying to setup a training database based on a survey that the supvs
take.  When they're answering the survey, the questions, the supvs info,
responses submitted, and response choices are all different tables.  When I
create a new question it may require two training classes ...

I would like to build an Access database for multiple users to enter and
retrieve data.  The database will be on a shared drive, but does Access
support multiple users possibly entering data at the same time?  I’ve built
one for a smaller group (2-3 people), but there will be 20+ ...

I have a table for equipment.
If the equipment has a service tag we use it as the primary key if the
equiment does not have a service tag we want to start at 0000001 and go up.  
Is there anyway to code this or have the primary key set to autonumber but

I have a table that must automatically create incremental numbers starting at
1000.
I have tried other suggestions I have seen on the web- eg Append queries,
they do not seem to work. I am using Access 2007

i have a table that is imported from excel.  the date is list as 4062008 for
04/06/08.  is there a way i can convert this to 20080406 or at best
04/06/2008.
any help is appreciated

Hello, is there a way to populate a table, where the records are in column by
column, as opposed to the standard row by row? For Example:
FIELD 1   FIELD2   FIELD3   FIELD4
DATA     DATA     DATA     DATA

How do I reset my Auto number to 0000 after putting in some test numbers it
now starts at 0010 even after I delete the  data?

Hello -
I have a set of data that I have broken out into two tables since there is a
lot of data. The tables are JOBS and QUOTES. The JOB NUMBER and the QUOTE
NUMBER should be the same. The JOB NUMBER field in the JOBS table is an

I want to creat a custom auto number starting at
2008-0001, 2008-0002,2008-0003 etc.
Suggestions

I am just starting to design a new database. My first one, so please be
patient with me!
I have a "Projects" table that has several fields. #, date, mgr, etc. I need
a field for the Resources (people) that are assigned to work on this project.

I need to create a db and was hoping there is one already created that I can
download.
I have a fibre collection, different types, different manufacturers,
different cross-sectional appearance, and other stats.  

I have a student who is building a table for a hair salon and the appointment
time cannot be later that 16:00 .  She has created a field using the short
time format and has an input mask, but this only ensures the format.  How can
she enter a validation rule to stop a later time ...