Hi I am looking for assistance with design of table. I need to track Event and Participants. I understand that I will need an intersection table to Join...

I've read the threads on the above -- and posted this problem in another user's group -- but still can't get it to work. It's on an intake form for hospital...

In my database I have a Sales table. The data in this table will be used to analyze and summarize Sales related info in various reports. For Cash Memos and...

We have a regional dbA. I was hired to create a new dbB for our location because my supervisor doesn’t like the interface for dbA. I believe dbB is a...

Hi Everyone, I am designing the new DB for my company, when i get the new order for customer, sometime they are using inches , but we are using mm for our...

When I use the Microsoft communities website to view this newsgroup, it shows up as Access Database Design, but posts I make here do not seem to appear on...

I would like some help on running a query from the switchboard, the query is a pivot chart, I added it to the switchboard with a command button to run the...

How do I set up a database where I may efficiently enter data from a town survey? There may be up to 35 questions, some with multiple answers. Thanks!

I am sure I am looking too deep into this but I have the following data and can not figure out how to oraganize it so I don't save duplicate data. This is for...

3 tables of referral sources and one 'join' table with an ID field common to all 3 (Resource ID). In Table 1, all items are Resource ID #1; in Table 2, all...

Hi, this is my scenario: tblClient, tblContract, tblEvent and tblEmployees. Clients have Contract and Contracts have Events. Example1: Client=Weddings.com,...

I’m having trouble on how to design the tables for my database. Currently I have 10 locations and they report their revenue each month by classification....

¹q62893103°Ý»ù©ÎµoªÅ¥Õ¹q¶l¥h »ù³æ.

I've noticed when I double click a line in my listbox, that if one of the fields has a blank value, my INSERT INTO statement bombs out when I double-click...

I'm sure that you've probably guessed why I'm here. I have three tables, a Person Table, an Item Table and a Sub Item Table. I want to create a fourth table...

This probably has already been covered, but I'm new to these Discussion Groups and I really need some help. I have an .asp sign in sheet that uses Access for...

I want to design a databse that ahndle general ledger like msaccess ledger template but in that template there is no check handling and bank reconcile...

Corrupted 97 DB Jetcomp and de-compile have not worked here The database runs and functions fine (except for an index error) for the users. Data entry...

Hi all, I have a database that serves as a file management application for a legal office. All the primary files are stored in a files table, which includes...

I am teaching myseld how to work in Access and have run into a stumper. I am trying to create a DB that will do the following: There are 12 study groups. ...