Search results

Seriously, YOU all are Great! Thanks!!! can you explain what the NZ is in the expression: Expr2: (Nz([field3])+Nz([field4])) thanks for helping a newbie out, I'm making big steps on learning this thanks to ya'll!

You guys rock!!! i got it! And, i learned a bunch as I made my mistakes on the path to success. thanks! I'm now looking for a sum of two fields, I'll poke around, but if someone could post that, I'd appreciate it! thanks!!!

Howdy Again! here's the sql that has built my DB... SELECT [08].station, [09].station, [08].precip, [09].precip FROM 08 RIGHT JOIN 09 ON [08].station=[09].station; UNION ALL SELECT [08].station, [09].station, [08].precip, [09].precip FROM 08 LEFT JOIN 09 ON [08].station=[09].station; UNION...

Howdy, a newbie here, and new to access, but pretty strong computer skills.. need you're help please.... trying to "merge" fields - i think merge is the right name for it... here's an example of the data... 100 ___ 200 200 300 ___ ___ 400 500 500 600 ___ ___ 700 where the ___ = empty I...