Search results

Can anyone still advise me on this issue?

I have tried everything to attach. Please email me your email address to josephsims77@gmail.com and I will send it that way.

Sure can, is there an easy way to do it?

This sounds good but I need some clarification on the step 2 (Make it a totals query). How would I do that. My results table has only two columns, ResultID and ResultName. The ResultID is the PK. I have created the queries based on the the desired result. Please explain futher Thanks

If anyone can help, I am still looking for a solution.

Thanks for the help, I will be here till 5 CST and until we figure this out i am just going to export the data into Excel.

I will remove the /. I do have the FK in place.

It is no problem. I want to be sure that it is right or close to it. I know it is working the way we need it to and if any revisions are needed i will correct them in a few weeks. There are a total of 7 tables. tblOEM/PN and tblResults are the ones that I am concerned with. tblOEM/PN looks...

I believe it is normalized. Could you please tell me why you think it is not? Maybe this is the issue.

The rating system is 0 - 8 and it is broken down as follows: 0 = New 1 = Scratch 2 = Spot 3 = Major Spot 4 = Scratch plus spot and so on.

Hello, I am in need of some major help. I have built a database to track what the quality of a particular part is and count it. Let me start over.... Business Rules: 1. OEN/PN is on multiple items. 2. Each screen item has a specific quality rating. 3. The rating system is based on the...

We have a new project coming up so I have created a simple Access database. Due to the enormouns amount of data entry we are going to be using bar code scanners. But this is the problem, when you enter data using a bar code scanner and want to move to the next field the enter key has to be...

Hello, I am relatively new to the database world and I hope to find an answer to my problem. Here it goes.... MS Access 2003 database that we use to track calls(phone) and to establish between the calls we have identified a call as either New or Called. When an associate follows up on the...