query for zero readinges

[afshin]

I have a one table with id_inc,id_pr,A1,B1,A3,B3 and reddate fields.readdate is date.id_inc is Name of instrument(inclinometer: vertical pipe),id_Pr is ID of every depth in that instrument, and A1,B1,A3,B3 is reading value in every depth in one reading date. instrument is similar pipe and in every reading of that may be pipe length is increases, so that the id_pr also increases. I want to distinguish A1,A3,B1,B3 value of every depth(id_pr) in first reading date of that depth.
in one pipe,in every depth, first reading date may be different from other, because pipe in some length is installed and read in some dates. in other date may be some pipe is added to that .so that in new pipe that add to old ones,in new reading of every added length have a zero reading date that different with below depths.

[rpeare]

Can you give an example of what your data looks like and what you want the end result to be because I do not follow your explanation at all.

[afshin]

in attached file I have a one inclinometer with three readings in three dates and in every 0.5 m of inclinometer pipe. In 15.10.2010 inclinometer height is only 49 m.but in other date is 60m or larger.I want to have A1,A3,B1 and B3 values in every 0.5 m in first reading. for example this value for 0.5m,in attached file is showed with yellow color and for 49.5 depth is showed with red color, for 60.5 m depth is showed with green color.

[rpeare]

I can't read 2007 files from my current machine if you can convert these to 2003 or lower I can take a look.