Fields in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Sirs
I have a query based on a table. In the query is one field which have to be
set automatically to "zero" at the end of the month (and should never be used
again) whereby the field in the table should show still the entered value.
Even after a daily update the record in the query should stay on zero and not
take again the record from the table.
Is that possible and if yes, how?
Thanks
Klaus
 
display field or 0 in query
---

Hi Klaus,

I am assuming yoyu have some way to know if the record is "closed"

in your query, you can do this:

columnname: IIF(condition, 0, [fieldname])

where:
columnname is what you want to call the column (cannot be a fieldname; I
often just put _ at the end of a fieldname so it looks the same but is
different)
condition is some expression evaluating to true (if record is closed) or
false
0 is what to display if condition is true
[fieldname] is what to display if condition is false


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top