Recent content by JosephMwaba

Hi There, I have a form that contains 30 text boxes. i have another text box (box a) on the form. i would like "box a" to count the other 30 boxes only when there is data in it. e.g if only 4 of the 30 boxes contain data, then "box a" should count 4. How do i sort this out? :-(

well..............................what can i say.............you are simply a Genius....!!!!!!!!! Thank you very much for your help!!! I really appreciate it.........! i will be in touch next time i am stuck...if you don't mind!

when i do that.....it changes all the fields to group by. when i only leave group by in the station fields and try to run the query,...........it say...you tried to executr a qury that does not include the specified expression "S1'1" as an aggregate function...something like that!

OH! I see what you mean! I'll try it now

what do you mean by "press the backwards

When i run the query, it works just fine. It gives me the different dates and the scores and the Station!! In The table there's one entry per station per day!! This is the SQL Statment SELECT Tbl_SubAttributes.Stations, Tbl_Inspection.Date, Tbl_Inspection.Shift...

the text box is unbound. I am not missing any Graphs...i have them all perfectly. The name will only appear when i put a recordsourse on the report.....but it will have 5 duplicates!

when it appears one, it shows me exactly what i want but without the station name. it says #Name? on the report header. you see i want the name of the station to appear on top of the report with all its 10 graphs 9 which are appearing just firn right now)

when i take the recordsource out............the report appears once but without the station name on top, instead i get... #Name?...

the other info on the report is the station name. i'll try to get the recordsource out will let you kow what happens!

Hi Kevin, Hope you are doing well. My database is now working perfectly...thanx to you. But there's a little issue.........everytime i press the report button it gives a preview of the report but on five different pages (Duplicates of the same report)! Any ideas

oooooyeeeees! It's working perfectly now......THANK YOU VERY MUCH... i mispelled the name of the text box on the form! You are a Genius..............I could Kiss you right now!

the code for one of the graphs is : SELECT (Format([Date],"DDDDD")),Avg([S1,1]) AS [AvgOfS1,1] FROM [Graph-Weekly] GROUP BY (Format([Date],"DDDDD")); "S1,1" is one of the 10 areas "Graph-Weekly" is the Query The Record Source for the Report is "Graph-Weekly

when i run the old report where i have to enter 10 times....the graphs appear with all the data on it. it's only when i run the new form that it only displays the layout. Is there anything else i need to do on the form you think.

Yeahhhhhh.....we're getting there. I have created the form as you required...the report is didplayed but only the layout without the actual values on the graphs. once i have entered the station name, and click on the button....the report appears just fine but without the data on it.