Search results

Thanks, I will try that out. It always helps to have a somewhat hands on example like that.

Thank you very much. That worked like a charm! Obviously I need to do some reading on Joins and SQL. I appreciate your figuring out the SQL statement for me, I don't think I could have devised that one in this stage of my Access and SQL knowledge.

Thanks for the hyperlink, that helped. The information in the database at this point is all dummy stuff for testing puposes, so it's not too sensitive right now. The report I'm having difficulty with is the "General Summary". It can be found from the "Materials Management" form that opens at...

Shadow, Thanks for your suggestion. I wasn't able to get it to work, but I'm also not great with Access especially coding. It might have just been the way I entered the information in the control source. I would like to upload a functioning mockup, but I'm not quite sure how to do that. Do...

I have a database for tracking materials purchases. One of the reports is a general summary that shows the Departments, Budgeted Amount, Encumbered Amount, Expended Amount and Percent Expended. It is based off of two queries (one that totals expenditures and one that totals encumbered amounts)...

Thanks missinglinq! I've been pulling my hair out for 2 days trying to resolve this and figure out the code. I didn't realize about the trusted site either, so excellent forward thinking there. :D

Hello all, I'm something of an Access 2007 newbie. I'm working on an invoicing db for work. I've got a Search Invoices form that is bound to the main invoice table. Basically I want users to be able to search invoices entered and update them if needed. They search the invoices through a combo...

That worked. Thank you!!! Steph

The Report Header is visible on the subreport. It's the labels from the Page Header that I can't move into the Report Header section. The labels are column headers for my report. Should I just create new labels in the Report Header and ignore the Page Header labels since they aren't displaying...

Hi, I've got a subreport that I need to have the page header display. Now, in reading on the forums I've discovered that a subreport can't dispaly the page header and that I should move the page header information into the report header to get it to display. However, I can't figure out how to...