Search results

Thanks Thank you. I saw the solution using an append query to count up from a given number, but nothing going back.

Good Morning, Is it possible to have an autonumber field start at a given number, say 9999999 and count backwards? I have a program that is generating badge ID numbers but I have a bunch that already exist and going backwards seems like the easiest way to mesh the 2.

OK, so I have the tables built and am importing the spreadsheet as a whole. So could someone give me a little kickstart on how I might go about tblCertifications? The Import table has the employee ID of each person and a field for each of the 18 pieces of equipment with a date in the field if...

One last thing...I am importing the certification info from a spreadsheet (excel). Should I import it to one table and then split it out or have several imports run grabbing only the info I need for each table

OK, this is pretty outside the box from what I was thinking, but it looks like I was going "tall and fat" as you said. I am going to redo some of this from the ground up as mine isn't going to be terribly practical it would appear. So back to the original issue, if my data is normalised as you...

Yes. The employee can be certified on any or all of the equipment and could thus be entered multiple times

OK, I think I am starting to follow, but how would these many dates be connected to a single person (The unique ID is the Employee ID)

hmm So I should have a seperate table for each piece of equipment then consisting of the unique identifier and the date of certification?

hmm, but I have about 15 pieces of equipment that can all have a different date. How would I get it all in one field?

What I am doing is printing a licence for them (report prints on a card). I want to list the fields that have a date in them on the back.

Thanks, but I need a little more That will indeed give me all the data in those fields, but what I am after is the field titles themselves

I have a table that has several fields that contain a date if a user is licenced to use a certain piece of equipment and is null if not. Each recor has other data in it such as name, and a unique identifier (numeric). What I want to do is make a list of the fields which have a date in them to...