DMAx code not working

[JackieSmith]

Hi,

I have a db that is giving me a problem. I have a form which contains a sub-form that displays data that is filtered from combo boxes and option buttons. This all works fine.

I now text boxes at the bottom of my main form which display certain data (count records in sub form, Average attendance, Average mark scored, and highest expense paid). These are all linked to text boxes in the footer of the sub form.

I have got working the count records and average attendance however the remaining two boxes are stumping me.

The problem I have encountered is the last box. I want to display the maximum cost of expenses displayed in the sub form. I have tried DMax as a start but I want to still view all the records in the subform however I need to display in the text box the value of the highest paid.

The current code in the text box is as follows:

=[front screen data subform].[Form]![Transport Expenses]

When applying the DMax to this it ceases to work. No error but the text box is left blank.

Any ideas??

[Rabbit]

You can't use DMax on a control. You use DMax on a table or query and you supply the field or expression you want to apply DMax to.

[JackieSmith]

any suggestions for an alternative then?? I need to meet the above criteria

Thanks

[NeoPa]

Suggestions are difficult at this stage, with so little meaningful information from you. You say you are trying to use DMax(), but you give no examples of how or where. Perhaps if you put the question down fully we would be in a position to be of more help. These tips are all explained in the sticky posts you should have read prior to posting your first question.

I suspect you need to use the Sum() function somewhere, but where will be much easier to determine with the relevant information available.

[JackieSmith]

I used the DMax code as mentioned above within the text box. It was used in expression builder. I am not looking to any summation of the data.

My intent is for the text box to display the maximum value displayed within the sub form that is under the heading Travel expenses.

[NeoPa]

My mistake. I used the term Sum() instead of Max(). The concept is the same. They are just two of many functions available in both Aggregate and Domain Aggregate types. The D of DMax() refers to Domain. I'm suggesting you need to use the simple Aggregate version instead.

[JackieSmith]

You were correct. When I altered to a simple Max code this worked correctly. Thanks for the help. Very appreciated!!

[NeoPa]

No worries Jackie. Glad to be of help :-)