Search results for query: *

No I am very Sorry Remou....still getting used to the the forums and I missed the link....however I searched on pass query parameters to a report and combos thereof....Thanks to You! and here's what I put in a text box in my header section and it worked great. ="From" &...

Thanks Remou for you reply again...not sure what U are saying. I will look into searching about that..thanks

I have another question I tried searching on this but I do not know if the key words are not getting any hits are what...But what I was wondering, is there a way for a keyed in input show up on a report ?...Example if You key the date in from 01/01/2006 to 12/30/2006...can that key in text show...

Here is the link! Look at the bar at the top of the page, lots of downloads and codes.... http://www.databasedev.co.uk/reports.html

I got it!!....who hooo....I had to cheat a little...I found a premade date select form on the web....edit to fit my needs ....thanks Remou for everything....U stuck with me till the end

I am back: I have the Date form built and changed the querys that runs my reports I typed in date and hit the cmd button and I have header and footer ...no chart or data.

Let me try again I think I messed up my date form. I will post back Thanks! I know we are getting closer.

Thanks Remou for the help. So I changed the sql to what you changed it to, and now I amm getting sytax errors. I really do not know what I am doing wrong with this. Thanks again for trying to help me.

yes I am using it one out of two reports...

BTW Tool Damage is a Table

Main Query Date Select is SELECT [Tool Damage].[Part Number], [Tool Damage].Technician, [Tool Damage].Date, [Tool Damage].Damage, [Tool Damage].[Total Cost], [Tool Damage].[Cost 1], [Tool Damage].[Cost 2], [Tool Damage].[Cost 3], [Tool Damage].[Cost 4], [Tool Damage].[Cost 5] FROM [Tool Damage]...

Tool Damage

Sorry I got messed up in my wording. A form called Reason and Cost for the report with the emmbeded form changed to pivot view to show the chart I follwed these steps to create it... report called reason and cost http://office.microsoft.com/en-us/access/HA010346001033.aspx?pid=CL100570041033...

Thanks for the reply A form called Reason and Cost for the report with the emmbeded form changed to pivot view to show the chart I follwed these steps to create it....then I draged in the report called reason and cost...

I still get the two dates I think it is because I dragged a report into another report. so its still promting me tfor two dates....been at this a long time very frustrated now...I am ready to leave it as a double start and end date report....any further ideas and explanations are welomed...TIA

The Report that creates the graph uses the main DB table The report that creates the written info below the graph is from a query I think...lol...Like I said I have been stuggling with access for a bout 3 months now I reall like the way this report looks like...its just a pain to type in date...

So with the two reports inside of one...Do I point the Record Source to the newly created form on each report?

I will check into this I am a noobie so bear with me...I have a query for the one for but not the other...maybe I need to redo the other report and query thanks

I finally got a report my boss likes to see. I have a report within a report. one report uses Microsoft graph to show 11 different items with the cost amount shown. the second report is the written output of the graph. Since these reports are for a given date range it is prompting twice for the...