I am new to MS Access and need to do the following: Write a report that groups payment of equal amounts for each vendor together. Ignore the sign (positive...

I am trying to count records in the report footer when a certain condition exist when calculating the difference between two fields, ie (-) = 0. Only count...

I have an existing database with "LastName", "FirstName", "Birthdate", "SpouseName" and "SpouseBirthdate" fields. I want to create a report that combines the...

In a subreport Sub I am trying to pick up the value of a field in the parent report, using Me.Parent!txtBox. I get an error saying You can't reference a...

I have seen several posts which come close to explaining what I'd like to do but nothing with the whole package... So here goes: I have a form that I enter...

I now have a wide-screen monitor. How can I make Access2003 default to showing (displaying) two pages, side by side, on the screen . I can do this manually,...

I have an existing report that includes a mailing address formatted to appear in a window envelope. This address now needs to have a postal barcode added to it...

I have a table (and form) that list Organs that have cancer. I want fill a text box with the word "Yes" if the Organ is Brain, or Lung. Any ideas? Thanks...

How can I format the following so the output will be % vs. currency? =IIf(()="Percent",(),IIf(()="Amount",(),''))

Hi Guys I have a reports sorted and grouped by the field machine, but in the detail I just want to show the first 5 records for that group. Any help will be...

I've created a lot of Access reports over the years, but none with as many subforms as this one. I'm creating a report that has a natural grouping on 1...

I am running a report that will display tunits for each member of our association. There are around 250 records that will have numerous tunits for different...

This is a bit a repost, but new information (or basically an entirely new problem) is available. I have a pretty complex query that only takes a second to...

I am setting a report, (like minimarket sales invoice ) when my report has print the footer note, the printer have to stop print, the paper wide is about 3"...

Hi. I have Windows XP Professional Version 2002 Service Pack 2 and have just upgraded from Office 2002 to Office 2007. Now, none of my snapshot files will...

I have a table with start date and end date, and I would like to create "MONTHLY" report based on the month of star date. Let's say if start date is...

Someone tried helping me out with this before, but we couldn't get the equation he suggested to work: I currently have an if then else statment in my report...

I've got a report that has a left margin of .75" and right margin of .25". I'd like to add some code to one of the forms events, that would shift this to...

Is there a way to create a row on a report that is optional? I'm trying to improve an existing report , that is generated from a link table. what i would...

Is there any way to output certain information in my database to either a monthly or weekly calendar format? The date is entered into the database and a...