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 lcan

  1. lcan

    date question - easy

    How do I format a date and time field in a query to pull data for items >1/1/2002 and < date()-1???
  2. lcan

    Need syntex help - simple

    I am converting this SQL statement from Access to Oracle. Can you help me? SELECT [814_24].DTM02_376 AS [Move Out Date], Count(*) AS [814-24 Count] FROM 814_24 GROUP BY [814_24].DTM02_376 ORDER BY [814_24].DTM02_376;
  3. lcan

    date query

    How can I get todays date plus 5 previous days to pull in from date/time field?
  4. lcan

    Need help totalling subreports in Main Report

    I have four subreports which have individual sum[countofemp] in each subreport. How can I get a grand total on the main report of two subreports [countofemp]??
  5. lcan

    Date problem

    I am trying to get a count of Employees for each month of the year. 1. I am having to do seperate queries for each month (with grouping for Date and Identifier and a Count for Employee)for each table 2. then making a table with those numbers and 3. then querying just Employee for a Count. Is...
See more

Part and Inventory Search

Back
Top