I'm running Access 2003 on Win XP Pro. On the category axis the source field has values of 01, 001, 00001, AB, ABC etc. The problem is when the chart...

Hi, I have a report. In the report, there is a field Current Market Value (CMV), and I am trying to create a grand total for it at the header or footer of the...

Hello, I am trying to update a report with new dates. I make the changes in the text and when I try to save it I get this message: Invalid Argument

I am trying to divide two columns and get a percentage and the following errors: #Div/0! (division by Zero error) #Num! (0 divide by 0 error) how do i Make...

I need to have the text not wrap when I export it to word so it does not have hard new lines inserted. I have tried to find help on how to trun this off and...

Hey, Access 2003 on XP Pro. I have a db I've been using for a long time and today I can't open the reports, in anyway using any method. VBA won't do it and...

Hi, I am using my database that I created as a job form tracking system. Every page of the hard copy form is a table in the database. I use a formID to...

I have a textbox, txtYMV, on my form, frm_BusinessGroup, where the user enters yyyymm value--i.e., 200906. So on my report, BusinessGroupReport_rpt, I have...

Access is part of the suite of products supplied to all workers in my federal government offices - many thousands of workers. Conceptually it is a great...

I am trying to sum a field in a report but I end up with a huge number as the underlying query is returning multiple instances of the numbers being summed. The...

I'm trying to sort a report on the value of a text box. The value of the txt box is built up of a number of IIf statements that together create a string from...

I have several subreports on a main report. If all of the subreports have no data, then I want to supress printing of the main report. Any ideas?

I created a new report and I don't want to use the table that I originally linked to the report when I first created it. Instead I want to link the report...

Hi, I managed to create a query of the same kind of data for 2 groups (see SQL query below) with your help and would now like to make a report with the...

I would like to group data on a report by week but can't figure out how to build the expression. Data comes from a date field in a query. Group titles would...

I am trying to keep track of which records have been printed. I have added a yes/no field to my table, and have an update query that sets the field to...