How to use DMAX

[tomneedshelp]

I am using DMAX to try to link a table to a from in access
any help would be great
thanks

[orange]

google DMAX techonthenet

[jzwp11]

Welcome to the forum!

You will have to be a little more specific. Typically, you would bind a form to a table and then you would use the domain aggregate function (DMax(), DMin(), DLookup(), DSum() etc.) to bring in 1 value from a table or query that is different from but related to the table to which the form is bound.

For example, you may have a form based on a client table and in that form you would display the total sales made to that client using the DSum() function. The DSum() function would use the sales table and you would filter it based on the key value corresponding to the client (which should be in a control on your client form).