K
Kristina Hangs via AccessMonster.com
Hi there,
I am creating a referral system in Access. I have to enter the names, and
locations of people that have been referred to the clinic. However, I also
need to show when reports for these referred people are due. For example, i
have been given a number of codes that have corresponding time frames. If
the code is 11, then the report is due two weeks from the original referral
date (to be manually input). This is easy to do with the LOOKUP table
function in Excel, but since I am creating this in Access, I need some
pointers on how to do this. A. Should I create a table for each code B.
Should I create a table with all the codes and their corresponding time
frames C. Should I somehow (and I have no clue how to do this) export the
referral info into an Excel spreadsheet where the LOOKUP table is already set
up. I would like to do it this way, but unsure of how to export data into a
spreadsheet with information in it already. PLEASE HELP!!!
I am creating a referral system in Access. I have to enter the names, and
locations of people that have been referred to the clinic. However, I also
need to show when reports for these referred people are due. For example, i
have been given a number of codes that have corresponding time frames. If
the code is 11, then the report is due two weeks from the original referral
date (to be manually input). This is easy to do with the LOOKUP table
function in Excel, but since I am creating this in Access, I need some
pointers on how to do this. A. Should I create a table for each code B.
Should I create a table with all the codes and their corresponding time
frames C. Should I somehow (and I have no clue how to do this) export the
referral info into an Excel spreadsheet where the LOOKUP table is already set
up. I would like to do it this way, but unsure of how to export data into a
spreadsheet with information in it already. PLEASE HELP!!!