Search results

  1. C

    Using DMAX in query with String criteria

    Hello. I've trawled the forum and thought I found the answer but it just gives me errors. Scenario: I have a table "RTr". It contains rows of names (NNN) and corresponding numerical data e.g. Score, Rating etc. The names in the table may be repeated in different rows as the numerical data...
  2. C

    Need to run Query twice to clear Error

    Thanks again. I've managed to make a user defined function - much easier than nesting my IF's. Cheers for the tip.
  3. C

    Need to run Query twice to clear Error

    Thanks. I've not used user-defined functions. I'll do some homework then try it out and let you know. Thanks for the reply. Chris
  4. C

    Need to run Query twice to clear Error

    Hi. I have a calculated field in my query but when I select the query the field contains #Error. I then change to design view and re-run the query and the field calculates properly. Is there a way to ensure the field calculates without having to run the query twice please. The calculation is...
  5. C

    Hi everyone

    Hello to you all. I'm a medium level user - I can modify VBA's, SQL etc. I have Office 365 on Windows 7 running on a Macbook bootcamp. :)
View older results
Back
Top Bottom