Thanks for responding again. I don't usually advertise myself as a programmer, because I only do Access these days (would rather do FoxPro, but there's a lot less demand for it). I learned my programming back in the COBOL RPG days. So I use "vendor" now. And you're right, it doesn't sound in and...
They've been using Excel, and it takes hours to do the payroll. I'm fully aware that it was a problem with the sheet the way they had it; but since I'm been programming for 35 years, I've figured out that our REAL purpose is to satisfy the client's needs, if possible, and to NOT project our own...
Well, I'm starting to think I'm in the wrong place to get answers. I've stated a couple of times that I know how to do this with related tables, which should have told you I have Access knowledge. I understand that I'm not an expert, but you are talking down to me.
Why is LoadNum blank? because...
Ah. I misunderstood your original question. There are more fields in the table. I full they are:
Date LoadNum SlotNum Jumper JumperCode Notes
2/1 1 1 Kay R T1
2/1 2 ALEC TM
2/1 3 JUSTIN VDO
2/1 4 James R T1
2/1...
One more time: I CANNOT use separate tables. The customer needs this information all on one table because of the way he operates. He is NOT willing to change his MO, so I have to come up with a way to make it work. I know how to use related tables; I can't, in this case.
Thanks for responding; however, the customer's needs prevent me from using multiple tables (which I know how to do). The field does not have to be hidden; don't know why I dropped that in. I've listed it in Access Tables and Relationships based on your recommendation.
I have a table that lists passengers on a skydiving trip. In order to make sure that the capacity of the aircraft is properly accounted for, each jumper must be listed. Also listed is a code field that tells the staff who is doing what for each jumper; the jumps are tandem jumps, where the...
I have a table that lists passengers on a skydiving trip. In order to make sure that the capacity of the aircraft is properly accounted for, each jumper must be listed. Also listed is a code field that tells the staff who is doing what for each jumper; the jumps are tandem jumps, where the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.