Search results

Can a custom field in a query return 'A' if condition 1 is met and 'B' if condition 1 isn't met? If title="supervisor" then run equation 'x'... if title does not ="supervisor" then do not run equation 'x'. Make sense?

My DB tracks quality assurance inspections. Each inspection can have 1, 2, or 3 nonconformities. Accordingly, there are 3 possible reports that can run as the final report. The argument/condition of the final report is formatted such that (noncon1=true and all others are false, open report 1...

I've got a report that, depending on some VBA criteria, could be 1, 2, 4 or 6 pages. If the criteria is met for the 6 page report, it comes out fine. For any other of the possibilities, however, the report has an additional blank page. I'm using 8.5 x 11 paper with 0.25 inch margins... my...

I've got a report that currently has 35 fields on it. Often, some of them are null... if this is the case, I don't want the field to be displayed. I can write 35 lines of VBA code, 1 visible=false line for each field... but is there an easier way? Can I group 30 of these fields together somehow...

My database tracks quality assurance inspections. I have a report that shows the results of each inspection for a queried time period. There are three spots on the report for inspection nonconformities. Currently, all three fields appear on the report, whether a nonconformity was assigned or...

In advance, forgive me =) My database tracks equipment quality assurance inspections. Each piece of equipment has a unique ID as well as a part number, serial number, and a noun. Equipment information is stored in Tbl1 (information changes regularly). The inspection results are stored in Tbl2...