Unwanted 0.00 on report

racdata

Registered User.
Local time
Today, 07:35
Joined
Oct 30, 2002
Messages
74
Hi everybody
I have a report (see attached file - unwanted.zip) It display all the R0.00 if there is no value for that fields.
Is it possible to hide all these R0.00 fields
I only want this fiels displayed if value is >R0.00 (R=South African Rand)

pls help me with this one
 
Last edited:
You need to edit the query where the report is generated from and in the criteria, put

<> "R0.00"

This should work
 
Kempes said:
You need to edit the query where the report is generated from and in the criteria, put

<> "R0.00"

This should work

Every field(on report) have a column in the query. This mean there are 120 culumns where I have to put in <>"0.00".
Then I get a error "query too complex"
What now??
 
providing all fields from that table are included in the query, rather than selecting each one individually, you could choose the * in the field option, Table name in the table option then <> "0.00" in the criteria. This will take up only one column in the query but when run will produce the correct information.

Otherwise, can you provide more details about your query and relating tables?
 
Copy of DB

Here is a copy of the db if you can solve the problem I thank you
 
Last edited:
I only have access 97 which cannot run this.
 
Someone else??

is there someone else who can help
 
I have had a look at the database and it is not normalised. In order to solve this problem, you are going to have to take a few steps back in order to address this problem, before you go on to design queries, forms and reports.

I have taken a look at the database design and taken my best shot at guessing what you might need and begun the process of normalisation for you.

However, you will still need to understand what I have done and more importantly why I have done it. Have a search on these forums; you will find several posts which list tutorials that will help you to normalise the db. If you have any questions the the General forum on these pages is the place to post them.

This may seem like a retrograde step, but belive me you will save yourself a ton of effort in the long term if you adress normalisation first.

Cheers from foggy UK
 

Attachments

Hide fields

From a other forum I have the following
Me.Sup1.Visible = (Sup1 >= 0.01)
Me.Sup2.Visible = (Sup2 >= 0.01)
Me.Sup3.Visible = (Sup3 >= 0.01)
Me.Sup4.Visible = (Sup4 >= 0.01)
Me.Sup5.Visible = (Sup5 >= 0.01)
Me.Lab1.Visible = (Lab1 >= 0.01)
Me.Lab2.Visible = (Lab2 >= 0.01)
Me.Lab3.Visible = (Lab3 >= 0.01)
Me.Lab4.Visible = (Lab4 >= 0.01)
Me.Lab5.Visible = (Lab5 >= 0.01)
Me.Ass1.Visible = (Ass1 >= 0.01)
Me.Ass2.Visible = (Ass2 >= 0.01)
Me.Ass3.Visible = (Ass3 >= 0.01)
Me.Ass4.Visible = (Ass4 >= 0.01)
Me.Ass5.Visible = (Ass5 >= 0.01)
Me.Sp1.Visible = (Sp1 >= 0.01)
Me.Sp2.Visible = (Sp2 >= 0.01)
Me.Sp3.Visible = (Sp3 >= 0.01)
Me.Sp4.Visible = (Sp4 >= 0.01)
Me.Sp5.Visible = (Sp5 >= 0.01)
It work fine for the first 5 rows but for each of this (Sup, Lab,Ass and Sp) there are 30 rows.
I get a Compile error when I ad Sup6 -see attached
 
Last edited:
The error message is you are seeing is because you have renamed the text-boxes on your report bound to fields Sup1-5 as Sup1-5, however the textbox bound to field Sup6 is named as Text168.

That is the immediate reason you are getting a compile error at that point. However - the bigger problem is that your database design does not adhere to a concept known as Normalisation (Normalization - for those in the US). You would be far better served to learn about normalisation, and (re-)design your database (table structure) to conform to those "rules" NOW instead of spending time re-naming some 120 textboxes on one report (if you don't fix this up-front the problem will snowball). What will happen when the day comes when a quote has more than 30 parts ?

May I strongly suggest you invest some time doing a search and some reading on normalisation, before you do any more development work.

Regards

John.
 

Users who are viewing this thread

Back
Top Bottom