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!

Search results for query: *

  1. mikeinfbg

    Another conditional group sorting question

    Awesome. That's what I was looking for. Thanks. Mike
  2. mikeinfbg

    Another conditional group sorting question

    Ok. I think I'm almost there. To shorten the formula, how would I write it so that: - if The register number falls into a certain numeric range, then use your first example and if it falls into another numeric range use the second example? - or better yet, is there a way to say "if...
  3. mikeinfbg

    Another conditional group sorting question

    I've throughly read through at least 7 other posts that might be similar to my question but still don't know if my situation is the same. I'm trying to summarize daily sales and sort based on which cash register they were rung up on. If the sales were wrung up on Register1, then I need the...
  4. mikeinfbg

    Getting totals for the same time period each year, or each month, or each week...

    I'm having difficulting on the "Selection" part of the process. As an example: I want to select all invoices that occurred on the Date July 1 but over several years, say 2008-2013. I can then compare sales based on those records for July 1st of each of those years.
  5. mikeinfbg

    Getting totals for the same time period each year, or each month, or each week...

    I have a data table called SALES. Fields include: Date; DateTime; InvoiceNum; Price. I am trying to write a formula (or set of formulas once I get the basic concept) that can do a few things and I am having great difficulty. All 3 of the following questions below boil down to me not knowing how...
  6. mikeinfbg

    Filling In Blank Fields in Report

    Version: CR XI Table: MENUITEM Table: EXCEPT Fields: menuitem.PLU Fields: except.PLU except.custno The MENUITEM table contains all of our products that we sell. The EXCEPT table contains any special customers that get...
  7. mikeinfbg

    Data missing on addition of another table

    This was what finally worked, just to close this thread. PRODUCT<<LOJ<<INVDETAIL<<IJ<<INVHEADER I turned off "Convert Database NULL values to Default" and my SQL query was: SELECT "INVDETAIL"."FullPrice", "INVDETAIL"."Qty", "INVDETAIL"."Dates", "INVDETAIL"."PLU", "INVDETAIL"."Cost"...
  8. mikeinfbg

    Data missing on addition of another table

    LBASS & Turkbear: Sorry I haven't gotten back. I've been trying your suggestions for the last 7 days and have tried to figure it out on my own, but to no avail. I had another idea though. INVDETAIL table contains all PLUs ever created AND sold. PRODUCT table contains only current PLUs. The ONLY...
  9. mikeinfbg

    Data missing on addition of another table

    VERSION: Crystal Reports XI Professional SELECT "INVDETAIL"."FullPrice", "INVDETAIL"."Qty", "INVDETAIL"."Dates", "INVDETAIL"."PLU", "INVDETAIL"."Cost", "INVDETAIL"."FullDesc", "INVDETAIL"."LQty", "INVDETAIL"."ConsignmentAmt", "INVDETAIL"."ExtPrice", "INVHEADER"."EmployeeNo"...
  10. mikeinfbg

    Data missing on addition of another table

    Still not working. I've worked all day at it. I'll try to summarize where I am. My joins are all Left Outer Joins. INVHEADER<<LOJ<<INVDETAIL<<LOJ<<PRODUCT<<LOJ<<DEPT The two tables that have the PLU field in them is INVDETAIL and PRODUCT. INVDETAIL will have records (PLUs) that are not in...
  11. mikeinfbg

    Data missing on addition of another table

    I had mistyped that in my original post, so even using your correction it still isn't allowing PLUs from the INVDETAIL table if that PLU isn't in the product table or deleted product table and therefore not associated with the DEPT (which I am filtering for). I understand how a record is not...
  12. mikeinfbg

    Data missing on addition of another table

    I've poured over this forum, and although there are similar threads to my question, I can't get it to work with my problem. Tables: PRODUCT (detail of things we sell by PLU#) INVHEADER (top level info of an invoice) INVDETAIL (detail by PRODUCT# of an invoice) DEPT (department to...
  13. mikeinfbg

    Summarizing Group Summaries

    Perfecto! Thanks LBASS. Mike
  14. mikeinfbg

    Summarizing Group Summaries

    My report summarizes the sales of clothing by each PLU or Item#. It is grouped by PLU and Group sorted by Maximum date to show me when the last time an Item was sold. Within the database each PLU belongs to only one department. My report shows the Department name on each grouping. So my report...

Part and Inventory Search

Back
Top