Search results

  1. J

    Subform controled by combo box will not requery

    I'm having a problem with a subform that will not requery. The subform is a datasheet that pulls price records based on a combo box in the main form. The query for the subform is as follows SELECT AFL_CustomerPrices.Matrix, AFL_CustomerPrices.Test, AFL_CustomerPrices.Method...
  2. J

    Concatenate field into additional query rows

    I have a frustrating problem that I could really use some help on (I'm not sure if the solution would be in the query or report) :confused: Our company have labels that we print on samples for testing. We have to have a separate label for every dilution in a test. What I need is a way so...
  3. J

    Create duplicate labels?

    I am working with a LIMS database that prints labels for samples that will be tested in the lab. The lab has chosen to denote different prep methods by imputing the values into one field separated by commas (this has been set by the lab and cannot be changed). The problem is the report that...
  4. J

    Count values outside of upper/lower limits

    My query that contains the fields Result LowerLimit UpperLimit I need a way to calculate the total number of Result values that fall outside of the upper and lower limits. What would be the best way to do this?
  5. J

    Crosstab column headings cause query to not have results

    I tried to set column headings on a crosstab query so that I can display them on a report (since the column headings change depending on the OrderID). When I added the code in bold, it caused the query to not display any results in those columns PIVOT Results.SampleNumber In ("Case 1","Case...
  6. J

    Concatenate field and remove duplicates

    I have a report that needs to take all of the values from a field concatenate them into a line and remove the duplicates. I have tried some VBA concat modules but haven't been successful in finding a solution. I need this: OrderID 1030 1031 1049 1053 1053 1054 1054 1054 1059 1059 1060 1060...
  7. J

    Combo box selection based on a different form

    I have a form that has a combo box that selects CustomerIDs and displays the correct record in the subform. The row source for this combo box is a table named cbCustomerIDs that the only field is a list of all the CustomerIDs. What I need is for the combo box to automatically select the...
  8. J

    IIf statement on bound object frame

    I need to know if you can put a conditional statement on a bound object frame. If a result has been approved it needs to display the signature of the person that reviewed it. If it has only been validated it needs to display the text "Results Not Final" I have a working statement on a...
Back
Top Bottom