424,479 Members | 2,260 Online
Need help? Post your question and get tips & solutions from a community of 424,479 IT Pros & Developers. It's quick & easy.

# Ecology and Access

 P: n/a Howdy, I'm looking for only a few hints - I need to figure as much of this out on my own as possible so I'll learn it. I'm doing a field study on a mosquito impoundment on some mangrove islands in Florida and instead of taking the easy way out and just using Excel I'd like to do this in Access. What I'm doing is doing belt transects across a dike and sampling vegetation, stem diameters and line intercept. Here's the physical data: Transect Number, Transect Length, 2 sets of GPS coordinates, a water depth reading. I'm thinking that in one table and link it to another by Transect Number. Then another table for line intercept data with plant species in a dropdown and then pairs of lengths along a tape measure, say black mangrove goes from 20cm to 45cm and also from 355cm to 500cm. I need it to subtract to determine each intercept and then sum them (15+145=150 in the above example). Yet another table for stem densities for each species, each stem diameter is measured twice and averaged. Then that will need to be summed. Any hints/suggestions would be greatly appreciated - not the answer, enough where I can (hopefully) figure out the answer for myself. Thanks! Jan 14 '06 #1
6 Replies

 P: n/a "salad" wrote in message news:fP*****************@newsread3.news.pas.earthl ink.net... snip Thanks for your reply. I did have some of that figured but got some valuable input as well. Basically what this thing is, is you lay a tape measure across the dike (it's about 25' across) and wherever a plant crosses the tape you measure it - think of it as casting a shadow on the ground and measuring the shadow. I've linked three tables by Transect_Number, the tables are Physical_Data, Intercept and Stem_Diameter. The part I'm having trouble with is setting it up so I have a place to enter the two numbers for each measurement - say 20 cm and 45cm so it'll spit out 25cm on a report. I'm guessing two separate columns and subtract them? Once I figure out one the rest will be easy. Jan 14 '06 #3