Search results for query: *

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

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...

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...

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.

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...

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...

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"...

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...

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"...

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...

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...

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...

Perfecto! Thanks LBASS. Mike

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...