Search results

Yes, Thats almost perfect. :) How to assign the one colour for specific area like in my charts above when only department elected, and how mohave only one colour for all of then when area selected? Thank you

Yes I can, please see attached.

No, still the same error: You tried to execute a query that does not include the specified expression '1' as part of an aggregate function. :/

Yes it's a query. The third query in previous post is the one. This error message, what does it actually mean? Is it just something simple like a bracket or comma or name or is it something serious that access doesn't understand how to deal with?

Hello all :) I am trying to transform a query as need to create a customisable graph in report, I got other 2 working but struggling with this one. Here are my 2 base queries: Q_YTDmonthlyAREAchart3_sub1 Q_YTDmonthlyAREAchart3_sub2 This is third query a combination of...

OK, will look into joins. Thank you for your great support.

Ok, got it working :) Now I want to create similar chart, but depending on selection in combo boxes the result will change. The previous chart was showing data for entire department as one bar for each month. The new chart needs to show each area in the department as individual bar, in each...

YOU ARE AWESOME!!!! Thank you. 1. Works great.... filters data depending on my cbo choices....even without the WHERE clause, but how? I don't understand where it takes the filters from, if there is no WHERE in the query? edit: ignore the above, silly question. Sub queries have WHERE clause...

I'm struggling with the pivot query: Can you help me please?

I want to display calculation data on the main form through report layout like I have at the moment. Do I need a separate query for each month then?

Ok, now I need to pivot the query to make it calculate data for all months at once. How do I do it without adding date field to the last query you provided?

OK, please see attached file. Open Form, I made comments inside. Thank you

Is there a way of changing this query int pivot query instead of having 12 different ones for each month? I in pivot query I need to have a month field, If I select dDateFound, it will limit my results when calculating fixed in current month, because a record can be found in one month but, but...

@arnelgp, Thanks, but I won't work this way as those 2 date fields are in the same record, therefore I am restricting count of Fixed (dateClosed). @plog, Yeah I thought the error might be caused by "" I took @arnelgp's idea and @plog's advice and heres my working query: Thank you both for...

Hello all, A union query counts how many records has a date entry, the second field counts how many records has another date entry. my query: Trying to calculate field in union query, but gives me this error: I need to do this calculation: Fixed/Found=Result Can anyone advice please?

@JHB, 1. Is it possible to have query as source? 2. Do I have to create a table to drop it all into? 3. Can I have more than 1 chart on the same report (based on the same query) Thanks Update: No longer relevant. Fixed it with pivot query.

All working now. Thank you very much for your help!

lovely!!!!! Thank you JHB I like the solution 2 as it doesnt leave report open in design after i'm finished. However neither of those 2 solution filter the actual report, but chart only. I added strWhere at the end of docmd. and this at the begining: Call cmdAPfilter_Click Dim strWhere As...

Oh yeah, No this query shows error with WHERE, I'm completely lost now :/ I've stripped all data from DB, please see attached file. Thank you