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 dencom 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: *

  • Users: mikeinfbg
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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