inserting a table

[vaseemali]

hello everyone



iam a newbie into access.iam a radiologist and want to add a table into access for reporting.i want the table in the following format.BPD,HC,AC, FL & AVG in rows and mm,weeks & days in columns.

mm weeks days
BPD
HC
AC
FL
AVG

i will be entering the values for BPD in mm,weeks & days,then HC in mm,weeks & days and so on and so forth.i could do that in word very easily but i cant figure out a way in access.so plz help.thnx in advance

[June7]

The reason you can't figure out how to use Access for this is that what you show is a spreadsheet arrangement. Access is a relational database.

We would have to know more about what you are trying to accomplish to better advise.

[vaseemali]

i am a radiologist by profession and am trying to create a form based on which i can create a report of antenatal ultrasound scan.here is a sample form.


INTERPRETATION: Real-time exam demonstrates a single intrauterine fetus in cephalic presentation with a regular cardiac rate of 147 beats per minute documented.

FETAL BIOMETRY:
BPD = 8.3 cm = 33 weeks, 4 days
HC = 30.2 cm = 33 weeks, 4 days
AC = 27.9 cm = 32 weeks, 0 days
FL = 6.4 cm = 33 weeks, 1 day

The head to abdomen circumference ratio is normal at 1.08, and the femur length to abdomen circumference ratio is normal at 23.0%. Estimated fetal weight is 2,001 grams.


these figures are different for every patient and i would like to collect a database of these values for statistical and archiving purposes

also have a look at this link to understand the complete form.
http://www.mtsamples.com/site/pages/...ltrasound%20OB
i was able to do the rest in access except this part of the form.i can do it in design view and manually rearrange the columns but i thought there might be an easier and "elegant" way of doing it in access.

thanks for the prompt reply.help is greatly appreciated

[June7]

That link is showing a sample report (data output), not a form for data entry (data input). Before designing a form/report you need to determine data structure. Not knowing what you have developed so far, hard to advise, but consider something like:

FetalBiometry (table name)
PatientID (primary key or foreign key to PatientInfo table)
DateBirth (not needed if PatientInfo table exists)
DateExam (the elapsed days/weeks/months would be calculated with the two dates)
DataType (BPD, HC, AC, FL, Weight, HeartRate - suggest this instead of field for each type because not all measurements appear to be taken at same time)
Measure

Ratios would be calculated on the report.