How to go to the record after using DMin

  • Thread starter Thread starter Saida
  • Start date Start date
S

Saida

I have a table that contains a Date, Part, Quantity

I use DMin to go to the earliest Date
How do I go to that record in order to modify the Quantity

All this must be done from a module

I'm using MS-Access 2003

any Hints will be appreciated
 
Saida said:
I have a table that contains a Date, Part, Quantity

I use DMin to go to the earliest Date
How do I go to that record in order to modify the Quantity

All this must be done from a module
Click to expand...

Personally, I'd prefer a SQL statement: something like

currentdb.execute "UPDATE thattable SET Quantity=" & theQuantity & "
WHERE Part='" & partno & "'"

Play a little how the SQL would look like with GROUP BY, to use the
Min() in SQL.
 
Back
Top