Spreadsheet in a record

J

Jobquest

Is it possible to enter a spreadsheet in a form so that each record can have
its own individual information entered by the user. If so - how do I go about
creating this?
 
S

scubadiver

Access and Excel are two completely different methods for recording
information. Can you clarify?
 
J

Jobquest

Hi - Thank you for your reply.

I have built a database in Access for my clients on a training programme and
each client has their own record recording all their personal information etc
etc. That all works fine but each month I have to submit a report to my
funders on each clients' attendance detailing dates of attendance so that I
can be paid.

I know I could set up spreadsheets in Excel and do it that way but wondered
if it was possible for a "mini" spreadsheet to be inserted into a record so
that I can enter the information there and thus keep all relevant information
for each client in one place only ie - their own record in Access. Every
client has different times of attendance so that is why it needs to be
individual to their record only.

Does that help???
 
S

scubadiver

Sorry to sound clueless but what information do you want to enter? Do I get
the impression you need another table?
 
J

Jobquest

Hi - It's probably my not explaining it properly.

Each client record opens up in it's own individual form what I would like is
for each record to have it's own "mini" spreadsheet on their form where I can
record:

Dates of attendance on the programme - Column 1
Fees I claim from the funders for each date of attendance - Column 2

Every client has different attendance dates and different amount of fees so
I need flexibility of entering what is relevant to each client

As I mentioned I could set this up solely in Excel but as I have the Access
database open all the time it would be so convenient to keep all the
information relating to the clients in their own records in the database.

Hoing you can shed some light...
 
S

scubadiver

Client information should be in one table and then you need a 'many' table
for programme attendance which would include attendance dates and fees.
 
Top