Having trouble switching to Expressions

[BradM]

Hello, I am new to Access and I have been using queries to create totals on reports and I am trying to switch to using expressions to keep it cleaner.


In my table the three colums are:


Module number
Pipesize
Pipelength


What I am trying to do is create a total length of pipes that are 2" or larger and have a module number starting with 1.

Any help would be appreciated. I have been using the expression builder and havn't had any luck.

 

[mdmilner]

Please paste in the SQL for the queries you are using.
In design mode, right click the blue bar (top of window) and select SQL View.

Paste in what you see here.

Mike