If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Table set up help
yes, every quarter, every physician will have new numbers to add into every
field. Do you think i would i need a new table for every quarter? "Gina Whipp" wrote: Colby, I can't tell you to add until I know what they are. Are they part of the quarterly figures you add? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... Thanks Gina, I am really grateful for the help. I am really new to access and appreciate all the help. Just one more question on the set up in the quarters table: tblQuarterlyFigures qfID qfPhysicianID (FK - relate to tblPhysicians) etc... is this where i would add qfQuarter qfAdmissions qfIfections etc? "Gina Whipp" wrote: Colby, Then the below tables should do it... tblPhysicians pPhysicianID (PK) etc... tblPhysicianContactNumbers pcnID pcnPhysicianID (FK - relate to tblPhysicians) pcnContactNumber pcnContactNumberType etc... tblQuarterlyFigures qfID qfPhysicianID (FK - relate to tblPhysicians) etc... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... Every quarter I will be manually entering them for each physician. Some will require a percentage calculation. "Gina Whipp" wrote: Colby, Where are the quarterly numbers soming from? Are you going to be entering something that will need to be calculated? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... I have a database that I am building and am very perplexed at how to set up the tables so that they will have the right relationships. I have a list of physicians and have to track the following: Contact information and quarterly numbers. I will need to be able to run a report for each physician that shows their numbers by quarter. Any ideas? |
#12
|
|||
|
|||
Table set up help
Colby,
No you do not need a new table for every quarter, just a field to add the which quarter it is. Then yes, that is the correct table to add those fields. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... yes, every quarter, every physician will have new numbers to add into every field. Do you think i would i need a new table for every quarter? "Gina Whipp" wrote: Colby, I can't tell you to add until I know what they are. Are they part of the quarterly figures you add? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... Thanks Gina, I am really grateful for the help. I am really new to access and appreciate all the help. Just one more question on the set up in the quarters table: tblQuarterlyFigures qfID qfPhysicianID (FK - relate to tblPhysicians) etc... is this where i would add qfQuarter qfAdmissions qfIfections etc? "Gina Whipp" wrote: Colby, Then the below tables should do it... tblPhysicians pPhysicianID (PK) etc... tblPhysicianContactNumbers pcnID pcnPhysicianID (FK - relate to tblPhysicians) pcnContactNumber pcnContactNumberType etc... tblQuarterlyFigures qfID qfPhysicianID (FK - relate to tblPhysicians) etc... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... Every quarter I will be manually entering them for each physician. Some will require a percentage calculation. "Gina Whipp" wrote: Colby, Where are the quarterly numbers soming from? Are you going to be entering something that will need to be calculated? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... I have a database that I am building and am very perplexed at how to set up the tables so that they will have the right relationships. I have a list of physicians and have to track the following: Contact information and quarterly numbers. I will need to be able to run a report for each physician that shows their numbers by quarter. Any ideas? |
#13
|
|||
|
|||
Table set up help
THANK YOU SO SO MUCH. That helps a bunch!
"Gina Whipp" wrote: Colby, No you do not need a new table for every quarter, just a field to add the which quarter it is. Then yes, that is the correct table to add those fields. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... yes, every quarter, every physician will have new numbers to add into every field. Do you think i would i need a new table for every quarter? "Gina Whipp" wrote: Colby, I can't tell you to add until I know what they are. Are they part of the quarterly figures you add? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... Thanks Gina, I am really grateful for the help. I am really new to access and appreciate all the help. Just one more question on the set up in the quarters table: tblQuarterlyFigures qfID qfPhysicianID (FK - relate to tblPhysicians) etc... is this where i would add qfQuarter qfAdmissions qfIfections etc? "Gina Whipp" wrote: Colby, Then the below tables should do it... tblPhysicians pPhysicianID (PK) etc... tblPhysicianContactNumbers pcnID pcnPhysicianID (FK - relate to tblPhysicians) pcnContactNumber pcnContactNumberType etc... tblQuarterlyFigures qfID qfPhysicianID (FK - relate to tblPhysicians) etc... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... Every quarter I will be manually entering them for each physician. Some will require a percentage calculation. "Gina Whipp" wrote: Colby, Where are the quarterly numbers soming from? Are you going to be entering something that will need to be calculated? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... I have a database that I am building and am very perplexed at how to set up the tables so that they will have the right relationships. I have a list of physicians and have to track the following: Contact information and quarterly numbers. I will need to be able to run a report for each physician that shows their numbers by quarter. Any ideas? |
#14
|
|||
|
|||
Table set up help
You're welcome!
-- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... THANK YOU SO SO MUCH. That helps a bunch! "Gina Whipp" wrote: Colby, No you do not need a new table for every quarter, just a field to add the which quarter it is. Then yes, that is the correct table to add those fields. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... yes, every quarter, every physician will have new numbers to add into every field. Do you think i would i need a new table for every quarter? "Gina Whipp" wrote: Colby, I can't tell you to add until I know what they are. Are they part of the quarterly figures you add? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... Thanks Gina, I am really grateful for the help. I am really new to access and appreciate all the help. Just one more question on the set up in the quarters table: tblQuarterlyFigures qfID qfPhysicianID (FK - relate to tblPhysicians) etc... is this where i would add qfQuarter qfAdmissions qfIfections etc? "Gina Whipp" wrote: Colby, Then the below tables should do it... tblPhysicians pPhysicianID (PK) etc... tblPhysicianContactNumbers pcnID pcnPhysicianID (FK - relate to tblPhysicians) pcnContactNumber pcnContactNumberType etc... tblQuarterlyFigures qfID qfPhysicianID (FK - relate to tblPhysicians) etc... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... Every quarter I will be manually entering them for each physician. Some will require a percentage calculation. "Gina Whipp" wrote: Colby, Where are the quarterly numbers soming from? Are you going to be entering something that will need to be calculated? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Colby" wrote in message ... I have a database that I am building and am very perplexed at how to set up the tables so that they will have the right relationships. I have a list of physicians and have to track the following: Contact information and quarterly numbers. I will need to be able to run a report for each physician that shows their numbers by quarter. Any ideas? |
#15
|
|||
|
|||
Table set up help
"Steve" wrote in message
m... Hello Colby, Get lost $teve. Another potential victim slips away thanks to Gina. |
|
Thread Tools | |
Display Modes | |
|
|