Access 2013 One record from many with same key

but as far as from where from and to, yes - we need to talk

From... I have an excel of course you know... in fact all 28

I have tables in Access of all 28

I have tables I've created with your help

Now, as far as appending a Query - an explanation would help.

I hope I

John,

Thank you again...

I apologize for the cross talk; I wasn't clear, but I believe I am now.

I'll see tomorrow.

Have a good one, and thank you all again.

I'm sorry, but we're still not communicating clearly. I don't know how to say it any better; maybe I should get another pair of eyes on this thread.

You do NOT NEED 28 VISITS TABLES.

You need ONE visits table, with ALL OF THE VISITS TO ALL 28 FACILITIES in it. Each row in the table will have a field to indicate which facility it is, and a field for the PersonID, and a field for the data, so you don't NEED a separate table for each facility.

This table will need to be populated from your spreadsheet, but as Scott says, it's not at all clear what your spreadsheet looks like. You posted:

Table: Facility A: Person - 123456 - Visits 4; Person - 234567 - Visits 5; Person - 345678 - Visits 2..

which looks (to me, maybe my inexperience with Excel conventions is showing) like one Row of a spreadsheet, possibly with multiple cells or maybe just one cell with semicolon separated data.

Then a few lines down you post

Facility A

Person        Visit

123456         4

234567         5

345678         2

Facility B

Person        Visit

123456         3

234567         4

456789         1

That appears to be the same data laid out differently. Is what you have in the five rows starting with "Facility A" one worksheet? one Workbook? an Excel Table object within a worksheet?  Do you have the same data displayed twice, once with all the values on one row and again as separate tables?

Remember: we can only see what you post. We can't see your screen, we can't read your mind! Could you please, as Scott also requested, post a picture of your spreadsheet?

And yes, of course you have to fill in the tables. I presume we can fill them in by running an Append Query from your spreadsheet, so no, you don't need to rekey anything! But until I understand what we're copying FROM then I can't help write the query.

John,

I have to fill the tables, first, right?

Just so I'm clear.

John,

When you say 3 tables are all I need...

__________________

1. I created a single Visits Table which will receive, I presume, the data for the Report.
   1. In the Visits Table I have Field Names only, IDBID], Name, ID, Facility ID, Visits
2. I created 28 Visits Tables, The only differences are their names; inside, they are Standard Formatted and empty. I presume the information is going in or through here on the way to the report.
   1. I created 28 Visits Queries to carry the data to the Visits Table (Singular)
3. I created the Facilities Table with the headings of ID, Facility, address – all filled out, I expect this is a reference table.
4. I created the Person’s Table, with all the pertinent information, ID, Name, all filled out, I expect this is a reference table.
5. Time for the Process

If you are reading this, I am working on the process.