Search results

Yes! The modified Maximum function is working now, without having to wrap the individual fields. Thank you pbaldy & vbaInet.

I am dealing with 15 fields. Some records hold an integer, some are blank. It seems that the 2nd through the 15 field can be blank, BUT there has to be a number in the 1st field, otherwise the maximum function returns a blank. Also, Not able to get the dang iif statement to work for some reason...

YES! It works almost perfectly. Only problem is the Maximum function does not seem to like empty records. I think I can resolve it by wrapping each field in the series in an if statement, like IIf([Field1]="",0,[Field1])

I would like to find the largest value for each row in a query. I have a query with several fields, each field has an expression that produces an integer. Max and DMax seem to pertain to the values in a single field; I need to evaluate values from multiple fields in a single row. I keep seeing...

Rare, fleeting moments... I took your advice and created kind of an exploded view table on my spreadsheet; it breaks up the confusing formula for calculating the 'New' column in to 5 different fields. It should hopefully be much easier to see how/what the formula does.

I am hoping that someone could help me convert a spreadsheet of formulas that rely on a rigidly limited data set, to a MS Access database with a data set that can be expanded. I play game that requires the use of regenerating resources to craft items. I have a spreadsheet with formulas that can...