Search results

Thanks it works!

How to add my own rows to a query in MsAccess ? I would like to do something like this: Select Name from Table 1 where age > 75 Union Select "Joe" from Dual; Expected Result: If Joe is not found in Table 1 ,then it would be added to the result of the query. How can I do it in MsAccess as...

Hi the code you provided works for forms but not for reports in Access 2007. My client does not allow me to upload my DB. This opens the form in PivotChart mode --- DoCmd.OpenForm stDocName, acFormPivotChart. My question is: How to create Pivot chart with graphs populated from a query...

I am using Access 2007. Thanks

Private Sub TestReport_Click() DoCmd.OpenReport "Report38", acViewPivotChart End Sub Hi I tried to open report as advised and received the below error message: Do I have to change any characterestics of the report that I am trying to open. Please help Run-time error '2505': An expression in...

I like to open a report as a pivot chart from my query. How to open a report by making the default view of report as pivot chart?. I am able to manually create a pivot chart by clicking pivot chart view from the sql view in a report. Then I pull in the required columns to the x axis and y axis...

The only way I was able to force the type to text was by adding a special character colon as a prefix to my data and that works. There may be other solutions but this works for me . Thanks for the help !

Select Year,Type,Count(*) from Table Group by Year,Type ; I am running the above query to create a bargraph: Result of my query: Year Type Count ---- ----- ------ OCt-10 Type1 5 Apr-11 Type 4 4 Expected graph: Y axis Counts X axis Year and then Type together Two bars in total ...

Unfortunately there is no option to change it to text or prefix the values with zeros in the legend.If you find any otpion please let me know

My legend in the piechart has values like 004,008 etc but while the report is created,the legend has the preceding 0's truncated and 004 is shown as 4 and 008 is shown as 8. Is there a way to fix that and avoid removal of preceding zeros in the legend. Thanks for the help !

Actually the graph works fine when I moved the bargraph to the report header section from the detail section. SO it works now. Thanks

Thanks for the help .I would like to have one bargraph per page in the final report with headings, subheadingsdate and few more values. Also,once the graph is generated,i would change the barchart values with vba code to change the color of each bar based on the xaxis value and I have the code...

Atleast 30 out of these 65 queries will be from same table (say for example Table 1)and each query will have a different criteria .The remaining 35 queries will be from another table (say Table 2). I think I may have to create subreports and try to merge them in the report header section so that...

I have to run 65 different queries and create 65 different graphs .Everything has to be combined /merged into a single pdf as a deliverable. As we do not have an option to creeate all 65 reports in one report header section, I should create several reports and then try to merge them i guess . I...

I am creating barcharts in the report header section but i think there is some size restiction and I am not able to add more than 3 graphs in the report header section. I have to add 65 graphs. Is there any way to do that . Please help and let me know how !!!

Report creates two bargraphs with two bars instead of 1 bargraph with two bars. The same query works fine in form and only one bargraph is created with two bars as expected. Am i missing something. A simple query creates this barchart.

I recieve this error in a report Runtime error '438': Object doesn't support this property or method Graph1.SeriesCollection(1).Points(j).Interior.Colo r = RGB(128, 100, 162) However,it works in form but causing error in report in Private Sub Report_Load().Could you please help !

I would like to select records that are between last week's Monday and Sunday .I should be able to run it during any day of this week. Is it possible to get a query that does Something like below Select * from table where (This Week's Monday date - Table.RecordDate) < 8 ;

I would like to know if I can read the values of x axis in a bargraph and change the color of each bar based on the value of x axis in MSACCESS using vba code. I appreciate your help !