Search results

Form Demo. Allows the choice of Customer Name and Project Name to be printed. There is a column in the query in the report that seems to relate to the Form Demo but I do not know how to change the query below to show only the project selected in the form? SELECT Tasks.ID AS TaskNo...

Yahoo! If a part of the equation is Null, will the formula not display? To calculate the Invoice Total in addition to what you gave me, this seems to be working =IIf([FSCPercentValue]>0,[FSCPercentValue]+[InvValue],IIf([FSCValue]>0,[FSCValue]+[InvValue],[InvValue])) !! My Text Box with the...

Steps 1 and 2 work great. Step 3 displayed on the first test before I added the Next two steps, now step 4 is visible on reports with an FSCPercent and is accurate. The property sheet for the Text Box called InvValue and the section of the form.

Hello, Thanks for reading this. First question is it possible to make a report so complex that Access can not handle all of the formulas? Second and more important. We have a report based on this query: SELECT Tasks.ID AS TaskNo, Customers.[Customer Number] AS CustomerNumber...

Re: New member in Florida USA I will try again to post the problem in the Reports Forum.

Hello Everyone! Access has been a useful tool for me since it came out. :) Always using a template or example database as a starting point, it has allowed me to solve several data management situations. :p More importantly in the past few years; a customer database for a non-profit...