S
SmartCookie
Hi - I'm not really a superuser by any means, but have been doing
queries and reports from Access for about 8 years. I'm stuck on a
problem though.
I'm reporting from our Accounting database which is new to me, and
there is a field called [glamnt] which is currency and another field
called [credit] which is a yes or no field showing up as 0 or -1.
I created two new columns in my make-table query with the following
expressions.
Dr: IIf([credit]=0,[glamnt],"")
Cr: IIf([credit]=-1,[glamnt],"")
I am getting the results I need, but am unable to format the numbers to
currency.
I can go to the table after I run the query and change it to Currency,
but I don't want to have to do that every time I run this report.
(This report is intended to be used company wide at will.)
Thanks so much for your help. ( I tried to search the group for an
answer, but was stumped on how to even search for this. )
Michelle Boggs
Cincinnati USA Regional Chamber
(e-mail address removed)
queries and reports from Access for about 8 years. I'm stuck on a
problem though.
I'm reporting from our Accounting database which is new to me, and
there is a field called [glamnt] which is currency and another field
called [credit] which is a yes or no field showing up as 0 or -1.
I created two new columns in my make-table query with the following
expressions.
Dr: IIf([credit]=0,[glamnt],"")
Cr: IIf([credit]=-1,[glamnt],"")
I am getting the results I need, but am unable to format the numbers to
currency.
I can go to the table after I run the query and change it to Currency,
but I don't want to have to do that every time I run this report.
(This report is intended to be used company wide at will.)
Thanks so much for your help. ( I tried to search the group for an
answer, but was stumped on how to even search for this. )
Michelle Boggs
Cincinnati USA Regional Chamber
(e-mail address removed)