Lookup Table

N

Nylex

I know how to look up a max number if I have the Table opened but how do I
find an answer if the table is not opened
Table Name “WorkOrders†Field with no in it “InvNoâ€
Is it possible
 
R

Rick Brandt

Nylex said:
I know how to look up a max number if I have the Table opened but how
do I find an answer if the table is not opened
Table Name "WorkOrders" Field with no in it "InvNo"
Is it possible
Click to expand...

In code, or in a form/report control expression you can use the
expression...
=DMax("InvNo", "WorkOrders")
 
Top