I want to create a database that uses calculated fields. The results would be printed in a report The calculations are basic as follows: Calculation...

I am trying to create a job tracking database. I have the company information in a separate table. And I created an event table to store all the...

I have a table with zip code, state, city, and county. The ZipID is used as a lookup in another table. How do I get all four columns to show on the form? ...

Hi everybody, I'm trying to design a table for my invertebrate data. I have many samples and over 70 taxa identified. However, most of these taxa are rare...

Access 2003 question: Does anyone know how to set up an automatic account number generation in Access? I suspect that it can be done with the Auto number, but...

I am ready to split a database. I know the general rule is for the FE to be loaded on each users computer. However, my question is, if all the users will be...

I have a field on a form that is "Date." I have the Date field set to =Now(). There is another field that is a check box called "Adverse Event." Currently...

I have a co-worker that would like me to build a database that centralizes a huge amount of data and am wondering if Access would even be the avenue to try...

Hi, Please forgive my long sad story of confusion and near despair, but I hope you can hang in there with me and help me figure this out. I don't mean to be...

I am in the process of desiging a database for maintaining and tracking data on all the equipments in my department. Each equipment has different features . ...

I have a table with an autonumber that I need to start with the number 20801. Access help says to change the New Values property. I don't see that property...

I'm debating (with myself) whether or not to archive records in a database and would like to hear opinions on what others may have done, or what others may...

Hi all, can anyone help with a wierd problem? I have been using a database for soem years, which involves a number of related tables. I have a table of...

What I need to do should be the simplest thing in the world, but I have scoured the training pages, the help files, faqs, technical articles and sample...

I have two fields in one of my tables that should only be populated if they're both populated. If either one is null, they must both be null. The fields are...

Hi Im trying to create a seating chart that is visible on a booking form and is updated everytime a booking is made for a performance (using that...

I'M TRYING TO SETUP A DATABASE FOR OUR REAL ESTATE RENTAL BUSINESS AND I AM BRAND NEW TO ACCESS. I NEED TO SHOW WHICH PARK THE UNITS ARE IN, THE ADDRESS,...

I'm a trainer and I need to delete the custom input masks that the students build.

I understand that I need to build table relationships based on IDs, not on text values that may change over the life of the database. I have read in this...

Could you please give me the design reasons for splitting a database - ie front end back end. I am building a database as it is being used (not ideal but life...