Search results

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

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

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

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

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

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