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 Shaun E 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: Ssnake57
  • Content: Threads
  • Order by date
  1. Ssnake57

    Converting MM/DD in Table to Days in Month in Query

    My Data in my Table is listed by Date, in my query I need to run a calculation on the number of days in that particular Month. Is this possible? Larry
  2. Ssnake57

    DATE BASED QUERY - IIf STATEMENT NOT WORKING

    I have a DataBase Table [Unit_Rental_Info]. My fields are [Unit #], [Total Cost], [Change Date], [New Cost]. I need my code set up so that in my Query it will show the [Total Cost] for all date ranges up to [Change Date], and the [New Cost] for all date ranges after Change Date? I tried...
  3. Ssnake57

    Duplicate Returns in Quarterly Query

    I am working on a data base on rental equipment. I have [Site], [Unit #], [Monthly Flow], [Month], [Start Date] & [Stop Date]. My Monthly Reports are working fine and the totals are accurate. My problem is when I try to do a Quarterly Query, I get duplicate numbers combining [Unit #] &...
  4. Ssnake57

    Can I Chart only 2 groups within a 3 group report

    I have an extensive report on equipment operating conditions. I am currently working with 100 pieces of equipment separated into 3 groups of "Critical Unit", "Mid-Range Unit", & "Non-Critical Unit". I am using 5 historical graphs, which I have designed for 5...

Part and Inventory Search

Back
Top