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

  1. pbardotz

    Distinct Count for Dates with Times

    I have a report where I want to count distinct dates. However the database has the time associated with the date. The distinct count takes into consideration the time as well. So for one date, I am getting three as the distinct count because the there are three different times for that date...
  2. pbardotz

    I am haveing a hard time understanding lookup tables

    I have not been able to construct lookup tables for my Access form entries. I am able to do lookups by having a one to many relationship in the query but that only gives me the information if I know the name or codes. Does anyone have an example of how to do a lookup table for a form or...
  3. pbardotz

    Date difference calculations in hours

    Thanks, for the advice, but when i try both formulas, i get error messages, indicating it can't find a variable.
  4. pbardotz

    Date difference calculations in hours

    I have a report that uses the formula from the sample Crystal Report "How to calculate business hours or business days" that doesn't work right. One formula for calculating days does work but the one for hours does not. In calculating the hours everything works well until you get to the second...

Part and Inventory Search

Back
Top