Thank you, in advance for your help. I need to determine best practices for establishing relationships between following tables. But first: I have clients who...

I have a table in Access that I run many update queries on to get the data in the correct format. Once this is completed, I then need to export this data...

I have a simple database for storing information about research articles. Fields on the input form include title, author, year, journal, type, keypoint1,...

I am using Access 2002. I have two tables. The primary table has an autonumber field which is set to increment. The field is a long integer.This field is set...

Hi, I have a set-up where I import an Excel spreadsheet (usually only 1 record) into a temporary table that is appended to one table (Artwork approval) in my...

Employee Table Employe ID AutoNumber Primary Name Number Secondary Number when i input NO.1 in Primary Name it should show me Persons name in the drop down...

am trying to build a database and need a query build to count times example Hound Number 999 score 35 Time 11:00 Hound Number 999 score 30 ...

I need to hold an inquiry to sick persons. I have: T_QuestionsGroups: IdGroup (with a primary key) and NameGroup fields; T_Questions: IdQuestion (with primary...

Hi All! I want to create a ("status") field in my contracts tracking table to tell me the status of the contract based on whether or not some other fields in...

Hi I am building a database for patient information and am having a problem at the earliest stage with the relationships. So far I have 3 main tables which I...

tbl_parts: part_id - autonumber - pk part_description - text tbl_bom: (bill of material) bom_id - autonumber - indexed(no dupes) part_id - number -...

Can you set format a field with a default that would calculate a date + 4 years and put that date in???

I have a table that hands out Entity IDs to every item in my database, that is every item now has a unique ID in the database as well as an Autonumber ID in...

How can I use 4 combo boxes to each show all information from a table? I am only able to get 2 combo boxes to show 2 table fields.

after working with Access 97 for years,i finally switched to 2000.i'm having a problem when i set up a new table with numerical fields (for example: a table...

We are building multiple databases for different purposes in the company and we are splitting each one of them with a front end and a back end. The front...

Total calculated time from 11:30pm to 12:10am is being returned as 23:20 instead of 00:40. Expression being used is =Format(-,"Short Time")

How do I go directly to a dataheet view when making a selection on a switchboard?

I have a database which tracks client investments. Periodically we have to recommend a change to these investments. When we recommend changes I need to...

Ok here is the situation. I a looking at setting up a database for my company that tracks manufactures/potential manufactures and their capabilities. What I...