Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pgh2377

  1. pgh2377

    Access Query Unique Count

    Unfortunatelty I don't know how to write SQL. Can anyone help me with unique counts by simply using the design view in a query. I've tried Dcount with works but when bring in the group names it just shows the group names and then the dcount of all records.
  2. pgh2377

    UNIQUE COUNT

    I have a patient table name "PATIENTS" and contains 3 fields: CLIENT PATIENT ID SALES Using access, because I don't know SQL, how do I group the Client, counting unique patients and summing sales. The patient may be in there twice for two different sales.
  3. pgh2377

    DCOUNT

    I have a patient table name "PATIENTS" and contains 3 fields: CLIENT PATIENT ID SALES Using access, because I don't know SQL, how do I group the Client, counting unique patients and summing sales. The patient may be in there twice for two different sales. I've been trying DCOUNT but having...
  4. pgh2377

    Option box to control another

    I have a form with multiple option boxes. Is there a way to have an option, for example one that says "TPA client" that when checked would allow an adjacent box to default?
  5. pgh2377

    Macro Question

    That sounds like a plan....any idea where I should begin?
  6. pgh2377

    Macro Question

    I have a macro that runs several queries and reports. On report may, or may not have data. Is there any way that a macro can be created with an if statement. In other words, if the report is blank, to skip the report?
  7. pgh2377

    Variance between weeks

    Well, I just started with =DMax("[DATE]","A1" and that worked great. Now if I can only get the rest...I trield the DMax first but got an error.
  8. pgh2377

    Variance between weeks

    I apologize for not being more in depth, your help has been great so far. Well, when I run it I get a zero. I thought I would start easy, so I have to the following: TABLE: A1 DATE STRENGTH RXS 11/28/04 25 25 12/5/04 25 30 =DSum("RXS","A1","[DATE]= #" &...
  9. pgh2377

    Variance between weeks

    Getting an error message, I need to show the difference between the stregths between the two weeks. For example, the 25 increased $10.
  10. pgh2377

    Variance between weeks

    I have a qry the does a make table. I enter in the date range (which is usually 2 weeks) and the table gives me the following: Week of Strenth sales 11/28/04 25 890 11/28/04 50 1090 12/5/04 25 900 12/5/04 50 1200
  11. pgh2377

    Variance between weeks

    I need to show the variance in a report between two different week periods. For example I have the following in a table: Week Sales Qty 11/28 $50 4 12/5 $35 3 I need a report that would show that, plus the variance: Week Sales Qty 11/28 $50 4...
  12. pgh2377

    Multiple reports in one

    Nevermind, I figured it out. Thank you for all of your help!
  13. pgh2377

    Multiple reports in one

    Do I place the subreport(s) in the detail section? If so, I'm still losing the page headers
  14. pgh2377

    Multiple reports in one

    dhookom, Thank you for your reply. O.k., to start what I have is about 7-8 reports that through a macro, print separately which is fine. However, through current requests I need to pdf the reports. To do so, I currently need to pdf print each one, then collaspe them into one pdf. I was...
  15. pgh2377

    Multiple reports in one

    dhookom, Would you be able to assist me step by step?
See more

Part and Inventory Search

Back
Top