group with different records

S

smay

I have an excel database which I need to send to Access. What I’m trying to
do is create a access page that allows me to output 20 different records on
one person on one page instead of having one person with 20 different record.
 
J

John Vinson

I have an excel database which I need to send to Access. What I’m trying to
do is create a access page that allows me to output 20 different records on
one person on one page instead of having one person with 20 different record.
Click to expand...

You've lost me here.

To import data from Excel into Access you don't need an "access page"
- you can use File... Get External Data... Import, and select Excel as
the data type for the import source.

Once in Access you would indeed want to normalize the data into two
tables, one table of People related one-to-many to a table with your
"records"; this would allow 20 (or 2, or 2381) records per person to
be entered.

Could you explain the nature of the records? Do you want to continue
to manage the data in Excel, or migrate the entire application to
Access?

John W. Vinson[MVP]
 
S

smay

Once I import my data to access, I will manage it in access.
I have three tables that I sent to access. That I want to make an access
page out of
One looks like this;
Name (Account number Org number Date Phone)
Doe, John 54545458 Dasf4ds5a 01/29/05
5551212
Doe, John 98589554 Af1da1 01/29/05 5551212
Smith, Don 00220000 Af1a1 02/8/06
6661212
Smith Don 01253255 21613a 02/8/06
6661212
Weber, Mike 85565544 A1f3da1fd 08/25/05 8881212
The Next looks like this
Name Record number
Doe, John 51545454
Smith, Don 95955584
Weber, Mike 894223669
The last looks like this

Name supervisor Supervisor signature
Doe, John Joe Tom Joe Tom
Smith, Don Tom Green Tom Green
Weber, Mike Test Man Test Man

What I want to do is create an access page that incorporates all three
tables but instead of having two or three records for John Doe I want one
record/page that list all information in ( ) on one sheet along with the
information from table 2 and 3
 
J

John Vinson

Once I import my data to access, I will manage it in access.
I have three tables that I sent to access. That I want to make an access
page out of
One looks like this;
Name (Account number Org number Date Phone)
Doe, John 54545458 Dasf4ds5a 01/29/05
5551212
Doe, John 98589554 Af1da1 01/29/05 5551212
Smith, Don 00220000 Af1a1 02/8/06
6661212
Smith Don 01253255 21613a 02/8/06
6661212
Weber, Mike 85565544 A1f3da1fd 08/25/05 8881212
The Next looks like this
Name Record number
Doe, John 51545454
Smith, Don 95955584
Weber, Mike 894223669
The last looks like this

Name supervisor Supervisor signature
Doe, John Joe Tom Joe Tom
Smith, Don Tom Green Tom Green
Weber, Mike Test Man Test Man

What I want to do is create an access page that incorporates all three
tables but instead of having two or three records for John Doe I want one
record/page that list all information in ( ) on one sheet along with the
information from table 2 and 3
Click to expand...

Word wrap made a comlete hash of your data - I can't figure out what
the data represents or how these tables are related.

Access does not use "access pages". It uses Forms for data entry and
editing, which may be what you're thinking of. A Form can have
Subforms - for instance, you could have a Form based on the Employee
table, with one or more Subforms for the related table. For printing
you can create Reports, in a similar way.

John W. Vinson[MVP]
 
Top