By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

IIf function in a report form

P: n/a
Dear all,

Could you give me a hint?

a) I generate a report from a query table, then I want to use this
report
to show the total numbers of the customers who buy the goods. There is a
string field "choose goods" in the table. Such field only contains either
"1" or "". Therefore, I write the IIF function on the report form at the
beginning of group row:

=IIf([choose goods]="1", "No. of customer to buy the goods", "No. of
customer not to buy the goods")

The expressed result is : No. of customer to buy the goods
99999
No. of customer not to buy the
goods 99999

However, the result is "#??" 99999
"#??" 99999
b) There is NO a field to indicate the serial number of the records in the
original table. As I want to general a report from a query table under
certain conditions, only some records will be selected. How can I general
the serial numbers for each records on the report, such that:

1 xxxxx xxxxxxx xxxxxx
2 xxxxx xxxxxxx xxxxxx
3 xxxxx xxxxxxx xxxxxx
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Dear Peter,

By the brief description you've given it looks like your table structure is
not very normalised. Can you please post your table structure so we can have
a look at it (remember no attachments allowed in this newsgroup). Once we
know your table structure we should be able to give you some advice in
correcting the table structure or be able to demonstrate how you can get the
results you want without using the IIF function.

With part b) of your question. You want the report to generate serial
numbers. If there are no serial numbers in the table, the report SHOULD NOT
be creating serial numbers. A serial number should be created, if the part
hasn't got one, at the time of data entry through a form. If the part has a
serial number, this should entered manually. You want the serial number to
be xxxxx xxxxxxx xxxxxx. What do the x's stand for? Numbers, letters?
Are these serial numbers going to be unique? After spending 20 years in the
engineering trade, I've seen the same serial numbers on different products
from different manufacturers. How do you want to increase the value of the
numbers? Since the report is going to create the serial numbers, how do you
stop the same serial number from appearing on a different part when
generating the same report with a different criteria?

Hope this helps.
Jeff
"Peter" <ci******@netvigator.com> wrote in message
news:cl*********@imsp212.netvigator.com...
Dear all,

Could you give me a hint?

a) I generate a report from a query table, then I want to use this
report
to show the total numbers of the customers who buy the goods. There is a
string field "choose goods" in the table. Such field only contains either "1" or "". Therefore, I write the IIF function on the report form at the beginning of group row:

=IIf([choose goods]="1", "No. of customer to buy the goods", "No. of
customer not to buy the goods")

The expressed result is : No. of customer to buy the goods
99999
No. of customer not to buy the
goods 99999

However, the result is "#??" 99999
"#??" 99999
b) There is NO a field to indicate the serial number of the records in the original table. As I want to general a report from a query table under
certain conditions, only some records will be selected. How can I general
the serial numbers for each records on the report, such that:

1 xxxxx xxxxxxx xxxxxx
2 xxxxx xxxxxxx xxxxxx
3 xxxxx xxxxxxx xxxxxx
.
.
Best regard,

Peter

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.