getting a value between 2 dates

  • Thread starter Thread starter Damien Brennan
  • Start date Start date
D

Damien Brennan

hi i have a database, that im using to to take monthly
readings on print qualities going through the printers.
so for month one the reading is 4545, and month 2 the
readings is 8966. i want to get the value of the actual
print qaulity for that month(8966-4545 = 4421) for each
month.
whats the best way to do this?
any ideas

damien
 
PQ=Me.txtPQ-DMax("[PQField]", "[TableName]", "[PQField]<" & Me.txtPQ)

Or in a query,

SELECT Table1.Test2, [Test2]-DMax("Test2","Table1","Test2<" & [Test2]) AS
Expr1
FROM Table1;
 
Back
Top