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 Rhinorhino 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 FluffyKitty

  1. FluffyKitty

    QUERY BY MONTH

    Thank you WildHare so much... I actually worked it out w/ a list box to select the months w/ a row source from a static months table (MonthNum & MonthName fields) and just bound that to my parameter query which points back to the list box, so when I select a month and click "print...
  2. FluffyKitty

    QUERY BY MONTH

    ok, here's the deal: > I have a date field [ReminderDate] > The user needs to be able to select a month (Jan-Dec) via a combo box on a form...then > I need the query to return all records that have the matching month (i.e. March) EXCEPT current year ('03) > Example: 3/1/01, 3/1/02, 3/1/03 -...
  3. FluffyKitty

    Running Totals - any advice?

    To: mtownbound... It's Thread: 149-182 Good Luck and if you have any good feedback/shortcuts please post them. This is a common problem for many and so far this is the 'best' place to get help. Thanks! :-)
  4. FluffyKitty

    Running Totals - any advice?

    here's what I have... These 2 calculated fields are located in the group footer which is grouped by USER_NAME... [TOTAL MINUTES] NumberVar TotalSec := datediff("s", minimum({qry_Efficenies.STATUS_DT},{qry_Efficenies.USER_NAME})...
  5. FluffyKitty

    Running Totals

    wow! nice response time :-) here's what I have... These 2 calculated fields are located in the group footer which is USER_NAME... [TOTAL MINUTES] NumberVar TotalSec := datediff("s", minimum({qry_Efficenies.STATUS_DT},{qry_Efficenies.USER_NAME})...
  6. FluffyKitty

    Running Totals

    Currently, I have created a RUNNING TOTAL that returns the total in (currency format) per GROUP. My goal is to add a new field in the REPORT FOOTER that will display the 'GRAND TOTAL' (an accumulation of the running totals). However, when I try to sum the running total it gives me the...
  7. FluffyKitty

    New Formula based on other Formula

    I currently have a report GROUPED by [Employee_Name] with the following fields: [Total_Orders], [Total_Minutes_per_Order], and [Total_Cost_per_Order] in the GROUP FOOTER. These calculations work great, but when I attempt to calculate the OVERALL [Avg_Cost_per_Order] in the REPORT FOOTER using...
  8. FluffyKitty

    Calculating Date/Time Field in Group

    Thanks in advance for your help. Problem: (Sales Database) I've grouped records by the Order_Number and each Order_Number has multiple records in the detail section. There is a Date/Time field used to track the order process. I would like to calculate the difference in time between the 1st...
See more

Part and Inventory Search

Back
Top