Truthfully, My experience only takes me as far as building queries in SQL view. I'm pretty knowledgeable with that and the process of creating databases that are standardized and uniform.

Right...

That's what I was afraid of, my unit will not pay for a consultant and I hardly make enough money to pay for one out of pocket.

The main reason...

Instead of the & "32" I would sub that out for & "=Date(ddd)" which will give you a 3 digit Julian date. that would give you a reference to when...

1. Create new table (Example: Table1) with ID as Field1 and SSN as Field2. Save and close the new table.

2. Open Query design:

3. right click and select show tables:

4....