I'm looking for the best design for a database I'm creating. I have a table that has 60 fields. The User wants to be able to bring up client records that...

I seem to have problems making different tables relate to one another. Monthly, I import trial balance information from an Excel spreadsheet into a new MS...

I'm designing an access 2003 DB for a small Newspaper. It will monitor the deadlines of the newspaper. Each record is a day. There are 5 people that could...

I need to track bank statement data. Statements must be grouped in the following order: by customer, bank, account, statement date, statement data. I already...

I have to create a database for transactions of school books. The Customer often pays by different combination of media, eg: Pay portion by cash and...

Greetings, We have an Access database that was originally designed back in Access 2.0 days. It's since been added to and convert numerous times; today it's an...

Hi all, I'll try to explain as much as I can what I want to do. I want an incoming notice paper to be in an access file along with some data... So we got one...

At this point my brain is, well, in turmoil. I hope I can get it back into some kind of working order. :) I have students who own dogs (1:M) ... so far so...

As a beginner I designed a database that uses bound forms and tables for different parts of a production process. I used a table for good product and another...

This is a three part question. 1st question: I'm creating a database for a pyramid type business. I'm giving each member a unique id by the auto...

I want to create a table that holds information about contracts and one of the columns will be a scanned image of a contract .tiff file. What is the best way...

I have a field in my Zip Code table called Current_Vendor_Count. This value is a calculation - it is calculated on a form. Is there a way I can store the...

I have a make table query that creates a null field called ClosedDate. This is essentially a place holder for an append query that later places data into...

Can anyone tell me how to set a start date depending on the day of the week. I have the following fields in a table, Creation Date = todays date Due Date =...

How do I validate duplciate values in a text field in a table. I have a field that cannot have duplicate records entered by the same dealer name. Do I use...

In my existing employees table, I need to add field to store data about the Housing Allowance employees are receiving from the Company. Not all the...

Hi all, In table design view for a text field I am aware that by using the '' or '' I can make the text appear either in Upper case or Lower case. However...

This is not a drop dead issue, yet is there a way to remove empty input mask entries or old ones that have been created? I've seemed to have collected a few...

Hello, I have 3 tables - employees, performance evals, and error codes. The error codes is more of a look-up table that is indexed by a unique number. The...

Re-posting in the correct sub-section. I originally posted in "Queries" where it obviously shouldn't be. I'm not a serial-poster, honestly (:o). I need to...