Search results

Hi, Does anyone know if it is possible in vb to actually change the type of chart you are using? I have a form which has a selection of buttons on it to choose a chart shown onscreen. These are all different views using a similiar data filtration. I require for example, a stacked frequency...

Sorted got it sorted... My Form had become attached to a copy of the crosstab aswell...god i hate it when developing a db under tight timescales...the timely errors that can be forcibly enduced!!!!!! Anyhows.....back to work now its sorted!!!!

Hi All, This is a simple problem i think....but am struggling to find a variable to change!. The problem is that i have a chart on a form, but the chart is replicated 22 times (i.e 22 charts on seperate pages)...there should only be 1! I have 22 variables on the X-Axis...so am presuming it is...

I guess you have maybe sorted this by now....but if i understand your problem right....all you need to do is goto the properties window of the chart and edit the sql in the source field. In here you get a design grid (same as in query design) and you can add or remove any fields you want. Hope...

Am experiencing a strange problem. i am using bar charts in a number of forms in a database developed in Ms Access 2002. The bars all have 3D effects on them(namely shading). When i view the form though the colours of the bars are all offset to the left. If i turn off the fill(3d) effects the...

i can;t run this query in a report have included the sql below. What i need is to group by [equip desc] and then take a product of those [critav] and [feedback av] which are in each group (see the attachment SELECT [qry Sub-System availability].[Equip Desc], [CRITAV]*100 AS CRITAVP...

total row It would be ideal if i could select (product) in the totals row. But access seems to only allow sum, count, max etc

Wonder if anyone can help? Am trying to utilize a product within a query. I have 4 columns, the first contains a set of systems. the next 3 columns contain percentage availabilities of these systems. My query will group the systems together(i.e all sub-systems of system A will group together...

Does anyone know whats wrong with this union query?????? I'm lost! I want to join the two query results together[qry WD by Asset] and [qry WD Asset total other column] SELECT [qry WD by Asset].[SumOfAnnualised Hours] AS [Annualised Hours], [qry WD by Asset].[Work Discipline] AS [Work...

Thanks, I'd actually managed to work out in the end that that was the sensible(or easiest way to do it!) its always the simplest tasks which seem to have you making more queries than you think you need!

Wonder if anyone knows the answer.... i have a query which runs and produces a set of results. There are always greater than 5 results. i want to view these in a report, but i would like them presented as the TOP 4 and then a column containing all the other data added together. i know i can...

sorted now.....persaverence(or a word spelt like that...ish) paid off!

if i remove the quotation marks it still doesn;t return any records. i've done this umpteen times recently...but this one seems to be really stubborn! Am tearing my hair out!

Any ideas why this returns a blank screen? SELECT tblWorkCentremonthlybreakdown.[Work Discipline], Sum(tblWorkCentremonthlybreakdown.[<=1m]) AS [SumOf<=1m], Sum(tblWorkCentremonthlybreakdown.[>1m<=3m]) AS [SumOf>1m<=3m], Sum(tblWorkCentremonthlybreakdown.[>3m<1Y]) AS [SumOf>3m<1Y]...

Still struggling Am still unable to do this!!!!!! help!!!! This is one of the last things i need to do to be able to complete the package i'm currently working on! Does anyone have any ideas????

its strange you should say that Keith, as that was my take on things too. I had expected a similiar approach to the IF statment in the criteria row to have the same effect. I guess there must be a logical answer as to why it doesn't work though!

Thankyou very much...problem solved. I had been trying to execute the If statement as a criteria rather than in a field. Can i ask what the <>FALSE statement does in the criteria row? i understand the If statement. Most importantly...it works!

MAT is a unique code within this query. In the previous esimple example i gave the "data" column (containing a, b, c, d, e wou) would be equivalent to MAT.

BIF is a string within a field. If my terminology is correct!. "BIF" is one of a number of 3 digit variables which occur uniquely within one column in my database query. Hope that makes a bit of sense!

found some code...but not sure about my syntax! I found an answer in the forum which suggested using an expression similiar to this : Running Total: DSum("[Total]","Query1","Year([Year]) <= " & Year([Year])) It was written by a user called ABBY i think. I've tried to change it to suit my...