Search results

OK... this is frustrating me to no end. I have tried using Google to search for report errors that would be similar and I haven't come across another problem like this at all. I have tried expanding the width of the text boxes and still no change. I have tried re-linking data and control...

Text boxes on report are squished and don't display properly? Seriously confused. Ok, I have been making reports for a database that will be shared between all the computers at my company's main office. I have about 6 or so reports that will be viewed daily by everyone. Every report looks...

Ok, putting it in the Report Footer made it work, but it confused me when it showed up above the page footer... considering the report footer is below the page footer in design view. Thanks again for all your help! Seems like you are the only one who ever helps me.

Wait... I think it did, but in a really REALLY odd place...

The report footer is not visible... not sure why. Even when I move it down there.

OK... made all of those changes... and while the Detail and RequestIDFooter ones still work, the bottom one; ReportFooter, is still saying #Error

This one is calculated by a query. I cannot change it without messing up my query.

OK, wait. The names of the three text boxes are: Detail: 'SumOfTicketCost' RequestIDFooter: 'TripCostSUM' PageFooter: 'TotalTicketCosts' The Control Source for each text box is: Detail: 'SumOfTicketCost' RequestIDFooter: '=Sum([SumOfTicketCost])'...

'SumOfTicketCost' But before you tell me about your's having a 's' on the end, I already noticed that and removed it before checking if it worked.

All the text boxes are named differently as I said before, and even with the formula you just gave me: I still am getting "#Error". :confused:

I get "# Error"

Hello everyone! Back for more help: Here is my problem now: I am trying to add up the complete costs of the tickets we book so that we can produce a report to our accounting department. Using Google I figured out how to get the totals for each "ticket" (The 1, 2, or 3 legged trips going only...

OK... you are simply awesome! The sub forms set to "can shrink" works perfectly. And I was able to make the main form look like the letter format I had wanted in the first place with expressions in unbound text boxes... and I had already made queries to pull the records from each form, so...

OK... I found a site using Google that gives step by step instructions for sub forms... and I gave them a shot. Looks like I may be able to get them working I just am haveing so trouble now getting only the data for one record (requestID) to show... am I going to have to make individual queries...

Wow... that sounds so simple. Ingeniously simple... except I have no experience with sub-reports at all. Will I be able to fit them on one page?

Attached are newer pictures of the report. This format only works if all records have data (as pictured in my lovely fake file for Anne Rice, Request ID 500), but it does not work as well for the records that only have one section, as displayed in booking 117. (Information blocked because of...

Rearranging the form is not the problem. The problem is that there will be lots of empty fields that the query is picking up when I don't want it to. I want to have the query only pick up the information for each request that has been completely filled out because there are going to be records...

Ok... attached are the pictures of the report. I know that by rearranging I can get all the fields on one page - however, as you can see Request 117 only has air travel information, but the query which the report is based on is still displaying all the other blanks. I want the query to only...

Ok... I'm beginning to really dislike Access reports... I have no idea what happened but all of the data has no magically decided to fit together on one page... now I just need to know how to make the query eliminate blank fields - because that should (keyword being should) eliminate all the...

Alright. I'll do a couple of the query in design view (it is way too long for one picture) and then I will take a few of the report and put them on the same photobucket album.