Search results

  1. C

    Where Condition not returning any items

    I have an OpenReport macro which currently uses a query as a filter, which works 100%. I attempted to add a where condition to further "filter" results. The statement reads: [Specialist]=[Forms]![frmSwitchboard]![lstSpecialist] Specialist is a text field in my main table; lstSpecialist is a...
  2. C

    Print Checkbox (on a report) only if checked

    As the topic title states, I want checkboxes to print on a report ONLY IF the checkbox value is "true" - if the checkbox is checked. If it is not checked, I don't want it to print at all. The report contains data from multiple records, some with the checkbox=1 and others with the checkbox=0.
  3. C

    How To Print Calculated Dates on Report

    I have an unbound text box (called "Due Date") on my form which calculates a due date of a project based on two factors, both of which are fields in the db: the type (selected from a combo box) and the Date I was assigned the project. The field names are "Type" and "DateReceived". The...
  4. C

    Leading Zeros in a Bound Textbox

    Not sure I'm using the right terminology, but I hope this makes sense: I have a text box that is bound to a combo box, such that the selection in the combo box (text) auto-populates the textbox (numbers). The textbox is used to display 5 digit numbers, some (but not all) with leading zeros. I...
  5. C

    Querying IsNull in multiple fields

    I'm trying to create an "IsNull" query that will return results if no value was found in EITHER one of two fields. For example: Field 1 = Create Ad Field 2 = Distribute Ad I would like to be able to search multiple records and return all records containing no value in EITHER field 1 or 2 (or...
Back
Top Bottom