Compute Value diferences between linesinQuery design View

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Ladies and gents Hi

I always run into the same problem erach time I used Query
Design View and want o take the difference between the
same filed in adjacent records. For example, one of my
fields is the total number of packets at a certain time.
Each record represents collected data at an arbitrary time.

Using the Query Design view and expressions, I'm trying to
find out the number of packets that were generated in each
time interval.

Thanks for help


Jack
 
When working in the design grid, you can select "Count" in the design grid's
Total row.
If you use an expression such as Count([FieldName]) into the design grid's
field row you must specify "Expression" in the Total row.

Either gives a count of the number of records with data in that field. Each
is counted, even whether the data is identical or not.
Records with no data for the field (null) count as 0.

Bruce Pick
 
Back
Top