Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JosephMwaba

    Setting up fields values

    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? :-(
  2. JosephMwaba

    Multiple Graphs on a report

    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!
  3. JosephMwaba

    Multiple Graphs on a report

    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!
  4. JosephMwaba

    Multiple Graphs on a report

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

    Multiple Graphs on a report

    what do you mean by "press the backwards
  6. JosephMwaba

    Multiple Graphs on a report

    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...
  7. JosephMwaba

    Multiple Graphs on a report

    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!
  8. JosephMwaba

    Multiple Graphs on a report

    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)
  9. JosephMwaba

    Multiple Graphs on a report

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

    Multiple Graphs on a report

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

    Multiple Graphs on a report

    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
  12. JosephMwaba

    Multiple Graphs on a report

    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!
  13. JosephMwaba

    Multiple Graphs on a report

    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
  14. JosephMwaba

    Multiple Graphs on a report

    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.
  15. JosephMwaba

    Multiple Graphs on a report

    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.
  16. JosephMwaba

    Multiple Graphs on a report

    overview of the database: Cleaning company has different sites to maintain. Each site has 10 areas to be cleaned. the 10 areas are scored everyday and scores are entered in database. the report need to show the site name on top and and 10 graphs showing the trends of the 10 areas. the sites are...
  17. JosephMwaba

    Multiple Graphs on a report

    Thank you very much for your help, i manually type the parameter in the query. i have entered the parameter as you suggested but when i try running the report it still asks to enter the parameter 10 times.it works just fine when i run the query. mind you the graphs show differents values. so...
  18. JosephMwaba

    Multiple Graphs on a report

    Hi there, i have created a database that produce 10 graphs on a report. The graphs get their data from a query and there's a parameter value to be entered. everytime i try to run the report, it asks me to enter the parameter value 10 times for each graph. and even when i want to print the report...

Part and Inventory Search

Back
Top