Search results

Hi All, I have read a few posts on here but can't quite get a solution to my particular issue. I have two tables in a query: tbl_suppliers tbl_supplier_perf tbl_suppliers is right joined with tbl_supplier_perf by [Location Name]----->[Supplier] No as part of tbl_supplier_perf there is a...

That's the one....needed a bit of "jiggery pokery", but done it. Thanks all. Ken you get the golden stick!

Na It needs to be on this first page. I cannot believe you just can't create a section for these graphs! Why does it have to be bound or ordered by something, why can't you just ahve a section of your report that you can place objects on? A bit like a header of footer, but in the body of the...

I see what you saying, but where do I put them? If the subreport is put in the detail section of the main report, it will be dplicated with every record?! I.e. I get a subreport for every record shown. I don't want that.

Hi All, I have a report, that has a detail section that shows an amount of records dependant upon the results of a query. Pretty straightforward, but I have no idea of the best place to put a could of graphs that I want to show on the same report! I can't put them in the detail section or...

Thanks Simon......You would have thought that yes, but no, it is still happening! It seems like the [Photo] and [Photo2] fields are being populated by previous records if they are blank!? Otherwise, with the code above, surely they would not be visible!?

Hi All, I have a really frustrating problem. I have a report that simply shows a list of records. The records contain file paths for images for various forms and reports within the database. There are two fileds in each record for the file paths, [Photo] and [Photo2]. In order that the...

Brian is spot on. I have managed to create the chart without having to update the references and it now seems to recognise the field [Enter Year]. I was trying to create this chart using the report wizard and I still believe that this maybe what the root cause of the errors was. I have now...

Thanks Brian, you're a legend. That works perfectly now!! Though I now fear MS Access charting, I do know a bit more about how to get them working as I want them to! Hope your meal was nice, I owe you a beer! :)

Well done Brian. I have found Access charting a complete pain in the ****!!! It was the Val bit that got it all working!!!!! Just one more thing though, when you produced the chart, where the months retained in numerical order, as they are in the query (owing to the link with the month number...

HI, Can I just ask with reference to the above. How can I get the results of Query 2 into number format, so that I can create a chart from them? At the moment, I am getting months and the Countof result from Query 1 but they are not classed as numbers. Access won't let me summerise the results...

Hi, Thanks for answering. I don't have either Excells on the list of references and I have no idea what this means! There is a field on the form called [Enter Year]. It is an unbound text box, for simply entering the relative year when running the query that feeds the chart!

Wasen't sure whether this is a Reporting thing or a Querie thing as it resides inbetween the two. Basically (and believe me I thought this would be pretty straight forward!!!!), I am trying to create a chart from a query that returns the occurences of concerns raised each month for a year...

It's OK I have figured it! This should be Mthtxt and Month fields are joined. This now works perfectly!

Thanks again Brian, this works perfectly...to a point! Query 1 works no problem. However there are 2 issues on Query 2: 1. Nz([name of Countfield from query1],0) does not seem to be picking up the values that Query 1 returns for the countfield, because it just shows 0 all the time. MthText...

I am infuriated with MS Access now!!!!! I am building a nice little system and now I am developing the reporting features. I want the results of a query to populate a chart. Basically it is a monthly chart, so would have 12 months along the x axis and a quantity on the Y. A simple line chart...

Thanks guys, I have actually adopted a much more simple approach: Month: Format([tbl_concern].[Date Raised],"mmm") Then it counts the occurences of entries compared to their relative month in the [Date Raised] field. However, can someone help with two further things: The above expression...

Hi and thanks Mstef, for posting the example. I have a couple of questions on using this query to suit my requirment: 1. How can I get it so the Year month combination has an "/" separating them? Preferably I would also like them to appear the other way around, so mm/yyyy! The expressions...

I find searching the site VERY VERY slow. Posting is not too much of a problem (finger crossed) and once the thread has loaded it isn't too bad to navigate multiple pages. Homepage loads fairly quickly but it really is searching that I find a real chore and loading threads takes ages too.:(...

It's OK I set the can shrink to both the sub report and the relevant sections of the main report and it works like a treat!!!! Thanks you guys for this thread, it has helped me out, no end. And no need for any VB code!