Spreadsheet in a record

  • Thread starter Thread starter Jobquest
  • Start date Start date
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?
 
Access and Excel are two completely different methods for recording
information. Can you clarify?
 
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???
 
Sorry to sound clueless but what information do you want to enter? Do I get
the impression you need another table?
 
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...
 
Client information should be in one table and then you need a 'many' table
for programme attendance which would include attendance dates and fees.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incorporating a spreadsheet or table into a record 8
Access Automatically Send a notification email once a record is added 0
Create Excel Lab test results 1
Access Count query 1
Cut & Paste in Excel without erasing cell borders? 1
Two autonumber fields in one table possible? 12
Transferspreadsheet question 4
Carry over date from previous record 1

Back
Top