|
| 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
September 27th, 2009, 10:11 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
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
September 27th, 2009, 10:18 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
September 27th, 2009, 10:24 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
September 27th, 2009, 10:55 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
October 1st, 2009, 10:04 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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 | |
|
|
Linear Mode
