Recent content by Agodf007

  1. A

    Create a serial number which automatically resets every month (Access 2003)

    How would I use dmax and count to make a product id and, in this way, would multiple users be able to use the same ID?
  2. A

    Averaging value if the date is the same

    I have many fields in my query. The query will only run if group by is located in all other fields too, defeating the "group by" in collect date.
  3. A

    Averaging value if the date is the same

    I am not sure if I understand. Could you expand? Thank you.
  4. A

    Averaging value if the date is the same

    I have a monthly report that I would like to run that averages results if they are from the same day. Is this possible? Collect Result Average Date 1/2/17 1 1/2/17 3 2 1/3/17 4 1/4/17 1 1/5/17 6 1/5/17 6 6
  5. A

    Issue with if statement using multiple criteria

    for some reason, result wouldn't work if it was being used in the criteria. However, numeric result did so this result is fixed. Myresult: nz(iif([numericresult]<[RDL],"<"&[RDL],[result]),"NA")
  6. A

    Issue with if statement using multiple criteria

    We use commas here. I am unable to provide a db as I am on a secure network and the db is large.
  7. A

    Issue with if statement using multiple criteria

    I am having trouble using the following code in a query. I keep getting an #error can someone please help me out? Myresult: nz(iif([result]<[RDL],"<"&[RDL],[result]),"NA")
See more
Top Bottom