Search results

Bizarrely, I think I may have fixed this now. There were no problems with missing references and all the spellings were consistent, but I have changed the TOTAL row to SUM instead of GROUP BY, which seems to have fixed it, it has got rid of the enter parameter box, and hasn't altered the...

Hi again, Thanks for looking at it again, I still can't find why the parameter box is appearing, the two fields are calculating the numbers correctly, but the box appears when you run the query, then when you return it without entering a figure it calculates correctly. The first field I have...

[/code] Please not that the long if statement above may not be the best way to do it, because it may be slow. Also, Excel has a nesting limit of 7, I am not sure if Access does to. If so, this method wont work. Also, the if statement may not be spot on, because I am not entirely sure if I...

Thanks for getting back. As any (or none) of the 3 fields can be null they need to be averaged in the final field by the number of fields that aren't null if that makes sense.

Dear all, I have a query with three fields: Head Slant, First Slant, Text Slant, All have possible values of -1 to +1 in .5 increments. some of the fields will contain null values, I need to find an average in a new field called Total Slant, that will average all three fields, taking nulls...