Generate table

  • Thread starter Thread starter Access Newbie
  • Start date Start date
A

Access Newbie

I have a large database of patients that I have set up a query to only select
patients in a specific floor. I want to create a table/form in Access OR
export the data to Excel so I can make a check out list to pass to other
providers covering for me. Below each piece of exported data, I want an area
that the person can edit. Currently people have to manually enter the
patient data in each box ox excel but it would be nice to pull some of the
data from my access database query. Is there a way to create a spreadsheet
in Access or Excel where I can specify the different data in each block of
the query to specif blocks in the spreadsheet.
ie. I want:
1) whatever is in the second row of the first column of the query to be
entered in the first row and second column of the spreadsheet
2) whatever is in the third column and third row in the query to be put in
the first row / second column in the table.

Can someone help me?
 
Hello Newbie:

There are a number of ways that this could be done:

1. Access appliation using forms
2. Excel solution with ODBC link to access.

Either way it is necessary to develope controls to ensure that your data is
properly controlled and entered and that users don't ruin your data.

Without the details of your database it is a little difficult to advise on
specifics.
 
Back
Top