Help with SQL Queries

I

itsrightthere

Here's a sample of values stored in my table takeoff

pipesize pipetype pipelength strcture structdepth(in ft)
6 pvc 23 b 5.6
12 pvc 67 e 4.3
12 pvc 34 mh 2.3
18 hdpe 12 fes 12 2.3


FYI: pipedepth is a result of calculations

I have all this in a form and I want to add a subfrom that would give
me structure depth where depth is between 0-2' 2-4' and so on

I want to do the same for the pipe where I would have form listing the
pipe for eg by depth

12 PVC 0-2' 24
2-4' 23

Thanks. If queries are not the best solution please don't hesitate to
give me other directions.
 
Top