Search results

All very valid points. How do you suggest I resolve this problem? I tried referencing the Group Footer control in the Report Header but got the same results as I did when I tried to put the control reference in the Group Header. You mentioned control triggering events. How would I trigger...

Here is a zipped copy of the Group Footer control calculations. I copied the original code into a Word document. How would I trigger an update to the Header control after the Footer control has finished calculating its value?

The Group Footer control is calculated after the data detail has fully run. This activity seems to work fine. However, when I try to reference this control in the Group Header, I get a value of 1. How would I trigger an update to the Header control after the Footer control has been calculated?

I have a report that has a calculated field in a group footer. I would like to reference the value of this calculated field in the group header. When I try to reference this field, using its control name, in the header I get the wrong value. Is there something special I need to be doing to...

[SOLVED] Creating a Master Query or Report From Multiple Queries I want to thank everyone who took the time to view my post. Since posting this problem I have developed code that will allow me to summarize my data at the report level. Thank You Everyone!!

I need help. I have been running 5 reports to gather company information. I then take the data from these 5 reports and manually load them into an Excel spreadsheet to calculate a grand total. I would like to be able to run a query or report within my database to get the same information. I...

I have a subreport created from a query. I am trying to imbed this unbounded subreport into my main report and I keep getting multiple summaries. Can anyone tell me why this is happening and how I can stop this from occuring? Thanks in advance

Downloaded and tried the MS JetCompact utility. This utility is great. It was able to recover all my data with no known issues. Thank you for recommending this approach. Thanks!!!

I am trying to repair my back-end database but am having trouble. Everytime I select 'Repair Database' I get the following error: '\\BE_Data.mdb' isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names.' Can anyone tell me what...

You are absolutely correct. The fault was mine. I misspelled DateAdd() by typing in DataAdd(). Thank you for helping me see the error in my typing.

Can anyone suggest a work around for the DateAdd() function. I have Access 97 and this function is not available.

I am using Access 97, I tried looking for the DateAdd function and could not find anything. Is this function available in Access 97? If not, is there a work around.

I have a query that takes a date from a selection form. Is there a way to window my data by taking this date and going back 12 months to give me a block of data covering this 12 month window. Example: Date entered is 03/dd/06 Date window desired is 04/01/05 thru 03/14/06

Thank you for your inputs. I started a chart from scratch and inputted it into a form instead of a report. Things were much easier. I appreciate you explaining this to me in simple terms so that a novice such as myself could understand. Thank you again.

Thank you so very much for pointing this out to me. Works as I had hoped it would. Could you help me to understand how to use the Chart Wizard and get the desired charting result. Being a novice to this I could use a bit of guideance on how to do this process correctly. Thanks

I am not sure I fully understand your response regarding the elimination of the GROUP BY statement. Could you look at the attached example database and demonstrate what you mean please?

I am using Access 97 and have been using a query to generate a text report. The data from this text report is being used to fill out various Excel spreadsheets to create some charts. I am trying to bypass this step and generate the graphs from within MSAccess using various reports. The...

I have been trying to create a chart within my reports. I have tried using the chart wizard but the results are not what I was expecting. Also to make matters even more complicated, I would like the chart to be 2-axis with numeric summations on Y-axis1 and percentages on Y-axis2. The X-axis...

I like the dialog box approach and was able to locate the file for data transfer, however, I still see that the dates are being being brought in as text strings and not dates. When I tried to change the field type to Date/Time it deleted all the data within the column. Also, could the code be...

I am having a bit of trouble importing an Excel file. The file has dates which are converted into a string of numbers when they are imported into my table. Whenever I tried to change the field type to Date/Time I would lose all the data within that column. I also tried saving the spreadsheet...