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

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

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

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

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

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

Hi wonder if anyone can help..... Am trying to filter a query based on whether a check box is selected or not. I've included the criteria row from my Query.... IIf([Forms]![frmfunctionlocation]![rbexcludeBIF]=-1,Not Like "BIF",Not "") I read this as... if the check box(rbexcludeBIF) has...

Hi wonder if anyone can help? Am trying to create a Pareto Graph in Access. i have a column of data which has percentages attached to it. I need to create a running total in another column, so i can graph this column as an accumulative percentage i think? Does anyone know how i can create a...