Search results

  1. A

    Display the record ID of the top or bottom value in a field

    Hello, I would like to display the ID of the member with the highest sales and the member with the lowest sales in the report footer as a calculated field. Is there a method to achieve this?
  2. A

    Email separate reports in PDF Format using outlook

    That works brilliantly, thank you! I need to filter the query to display data in the report separately for each of the recipients in the listbox, how do I achieve this?
  3. A

    Email separate reports in PDF Format using outlook

    Uncle Gizmo, Gina's script works perfectly for sending the same document to multiple recipients. How can I add my e-mail signature to the mail and format the writing with line breaks?
  4. A

    Email separate reports in PDF Format using outlook

    I have started playing with Ranman's script - thank you Ranman I created a list and named it lstEAddrs and amended the code to suit the database, upon running the code , I am presented with this error:
  5. A

    Email separate reports in PDF Format using outlook

    I am sure that there are numerous threads on this already, but I can't seem to find the one that fits my scenario: I have a relational database with a table with the names of recipients and their email addresses and I have a report based on a query. I want to e-mail the report in PDF format...
  6. A

    Enter parameter value

    OK, so that worked temporarily, but now when I closed and re-opened it and I was prompted again by the same Input Parameter value error. This is what I have in the Open Report Macr which is assigned to a command button on the form named Form1. [Forms]![Form1]![Combo0]=[qry_Loans]![Class]...
  7. A

    Enter parameter value

    It was an unbound form (but I added a record source to it now) and it works! I didn't think it needed a record source as the form is being used as a menu?
  8. A

    Enter parameter value

    I have a form with two combo boxes I have a command button assigned to a MACRO which will open a report based on the values entered in the combos. Everything was working fine until I closed the database and re-opened it and now it says Enter Parameter Value followed by: Forms!frm_Name!Combo21...
  9. A

    Excluding Wild Card Search

    =Count(IIf([Grade]="A*") How do I get this to only count A* grades and prevent it from performing like a wild card search. I know this might be something simple, but just can't figure it out.
  10. A

    Cross Tab with text values and no totals

    I need a query set up similar to a cross tab, I just want to show the text values, without summary totals. How do I achieve this? Columns: Name, Grade_Unit1, Grade_Unit_2 etc Data Rows: John, C, A
  11. A

    #Error - Form Field

    Great, strangely, DCOUNT has brought the values back. Sorry for the late reply - I was away from office.
  12. A

    #Error - Form Field

    These were test fields, my bad - should have deleted them
  13. A

    #Error - Form Field

    Everything was displaying fine in the textboxes which contained some calculated values and then all of a sudden I was presented with #error? I don't recall renaming any fields/objects..what could be the problem? Database attached.
  14. A

    Cross Tab - Data Type Mismatch in Criteria Expression

    Thank you so much for spotting these minor mistakes.
  15. A

    Cross Tab - Data Type Mismatch in Criteria Expression

    Hi, I changed the data to preserve confidentiality, it still did not run prior to this.
  16. A

    Cross Tab - Data Type Mismatch in Criteria Expression

    Hi, I have attached the database. It has the source query as well as the crosstab query. The query works fine if the mark field is used as the SUM, however, if I use the percentage field which is a calculated field, it brings up a mismatch error.
  17. A

    Cross Tab - Data Type Mismatch in Criteria Expression

    Hi. Thank you. Despite the editing, I am still getting the mismatch error. :(
  18. A

    Cross Tab - Data Type Mismatch in Criteria Expression

    Here is the source query
  19. A

    Cross Tab - Data Type Mismatch in Criteria Expression

    I have set it to general number but no other formatting has been applied
  20. A

    Cross Tab - Data Type Mismatch in Criteria Expression

    Hi, I am not quite sure how to set that in the SQL?
Back
Top Bottom