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...

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...

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...

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,...

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...

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 ...

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...

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,...

Hi there, 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...

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...

I've looked high and low but can not find out how to re-enable the "Allow full menus" option once it has been set. -- ChrisH

In a design consult, i have three fields, the first one is result of a group, and the others are sums from fields of two tables. Here is the SQL: SELECT...

I have been tasked with converting our Excel Statistics workbook into an Access database. Our department (a records department) tracks statisics on each task...

Hi everyone ! I would appreciate anyone who could guide me to develop this database. Let me make it simple and short Database name : PE Database Tables :...

I have an older version of access I wrote macros to capitalize first letters in a field. EX : 25 Lee Street The command would automatically make the L...

I am creating a clinical research database and I am having trouble with some of the design logic. Each Protocol has a unique Budget. Each Budget includes...

Hi there! I am hoping someone can help me weed through this mess of relationships and set up a logical structure. Hopefully I can lay this problem out...