Search results

  1. C

    data type mismatch in criteria expression

    Hoping someone can shine a light on this please... I have two queries which I join to form another list of data. However, I get the "data type mismatch in criteria expression" error. The joined fields are sourced from two separate tables and are both Short Text in the source tables. I have...
  2. C

    Count dates with value between 6 months and 18 months old

    Hi, Hopefully a quick problem to solve but I've been struggling for past few hours. All I want to do is count how many records (within a set of grouped records) are between 18 months and 6 months old and ALSO count how many records are less than 6 months old eg. My query...
  3. C

    Comparing Row N with Row N+1 to Calculate a new Field

    Hoping for a little more help please. I have a database which has many fields including: Location, Date, Time, GenRate, SysData, etc. There will be several records having the same Loc/Date/Time and different GenR/SysData etc. (sample data below). I did some research and think I may need to use...
  4. C

    User Defined Function - Not returning expected value

    I've been trying to use some UDF's and have got a small problem. The Function does not return the value I calculate manually. I think it may be something to do with the syntax of the arguments and would welcome help to sort it please. My Query Table is "Today_Time_Track_b" which is made up from...
  5. 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...
  6. 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...
  7. 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. :)
Top Bottom