Search results

Hello. I have a Project database that has a query to calculate the quantities that need to be ordered. Items are entered in a subform which populates a table. I created a query that takes the QTY Needed subtracts QTY on hand and Qty on order. The first query pulls the QTY needed from the...

I have a report that has a "comments" field that can grow. I need to get vertical lines between the headers to form columns. How can I make the vertical lines grow with the fields so that it looks like one continuous line from top to bottom? Thanks!

Hello. I have a report that has a status field that is either R, Y, or G. R = RED, Y = YELLOW, and G = GREEN. On the data entry form I am using check boxes to select the status for each. When we are reporting this to upper mgmnt they have a very specific format they want to see this in...

Hello. I have created a DB to manage our projects (ATM installations). Once a week a summary report is provided to upper management giving them the status of each project. On this summary report they want to see a "percent complete". This percent is derived from the status fields (approvals...

Hello again... I have a report that has a subreport that can have multiple records. Right now if I have more than 6 records in the subform it throws the rest on a new page. This is fine with one small exception, it is putting the page footer on every page. How can I tell it to only print on...

Hello. I have a report with a subreport and am having issue with it printing correctly. The subreport can have multiple records and I want them to all print on one page. The report works except that if i have 6 records in the subform it prints the same info on 6 pages. How can I prevent the...

Hello. I have scoured the forum for an answer but have not been able to piece one together. Here is what I am trying to do.... We occassionally have to scrap inventory and in order to be audit complient we have to have a control number and log for each form created. Currently we are doing...

Hello. I would consider my self an intermediate Access user, however, I have been tasked with building a "project" database for work and have reached the outer realm of my knowledge. Here is what I am attempting to do.... I work for an ATM company and we receive information from our sales...