Volume table

[AVINANAIR]

Sir, I am beginner in ms access, working in Forest Department, I have a plan to create a software using access to find out the volume of standing trees. There is table called NR nair Volume table. Species Name, Girth, Volume. All datas are already recorded
Species Girth (Cm) Volume (m3)
Eg: Teak 85 0.35
Like the above around 32 species up to 285 girth are available. girth recorded as 75, 85, 95,105,115, so on ......



I want to put them in a data base and create a soft ware to find out the volume while selecting species name from a combo box and type girth in a text box

But I could not done success fully. I have create 2 table. One for species.. Name of species, Scientific Name, Name in malayalam

Table 2 is Girth table consists of 1. ID, Species ID, G75, G85 ,G95,....up to G285 and Data entry for the species and Girth of each species were completed. The one to many relation ship with table 1 to table 2 was also created. (Table1ID to table 2 second field ie Species ID)
But i could not attain the goal which I have already described above. Please help me.......

[ranman256]

TGirth table should have 2 columns:
[SpeciesID],[Girth]
1, G75
1,G85
etc

the table gives N girths per tree. If that's what you need.

[AVINANAIR]

Thax for ur valuable reply sir..There is no formula to find out volume of tree.. All volumes are already calculated through research and analysis of datas from the field. Hence I think another table for volume is required ? ie for a species and for a girth. Is it right sir?