Recent content by ~Rachelle~

  1. R

    Rookie banging head against wall with iif

    HALLELUJAH!!!!!! YES! :D No longer >> :banghead:. This is terrific. I have really learned a lot with this database. Bad rookie will not put calc fields in tables anymore. Lesson learned. Thanks so much Galaxiom and MarlaC for the hints/guidance. I am an instructor in a completely...
  2. R

    Rookie banging head against wall with iif

    Thank you Marla, a light is coming on. Ok, I think I get it. I am probably going to break it while trying to fix it, though. It is fed from a query that is based on (some) calculated table fields. I believe I need to do all the calculations, then, in the query and not in the table. (?) (Am...
  3. R

    Rookie banging head against wall with iif

    Thank you. Not sure that I get it but I'm trying.
  4. R

    Rookie banging head against wall with iif

    I am a major rookie sorting my way thru here... I would deeply appreciate any assistance I can get on my report. What I would like to do is add two fields together and then if the result is more than 245, have it return 245. If it is less than 245, have it return the true value. Here is...
Back
Top Bottom