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 Chriss Miller 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. rtoguchi

    Date Difference

    Thank you for the quick responses, but For "Today's date", I am looking for something like "Date()" in Excell, so that it will always be "Due Date" - Today's date(which always changes).
  2. rtoguchi

    Date Difference

    In Excell, I would like to create a formula that shows the difference between two dates. I know how to do this for an Access query, but not in Excell. I would want the put the equation in the "Days until Due" column." Due Date Today's Date Days until Due 5/20/04 5/19/04...
  3. rtoguchi

    Excel question

    Hello, Could someone please help with an Excel question? I would like to do an "If" statement so that Box A will say "Y" or "N"(or different color, or anything similar), depending on if Box B is greater than or less than box C Box A Box B Box C Y 5...
  4. rtoguchi

    Linking Microsoft Access to Pervasive SQL 2000

    Hello, My company is using Pervasive SQL 2000 when running reports and finding data off their database. I would like to use Microsoft Access so I can create/run my own reports/forms/queries, but can't seem to find the tables to link to. Any suggestion on how/where to find the tables...
  5. rtoguchi

    Start Date/End Date on a report?

    Thank You, it definitely solved the problem.
  6. rtoguchi

    Start Date/End Date on a report?

    Hi, In my query, I filter the data based on a date range. In the date column from my table, I use the "Between [Start Date] and [End Date]." Is there any way to include the dates I am entering onto the report? Like in a text box for "Start Date" and "End Date"?
  7. rtoguchi

    Help with conditional sums in Access Reports

    Thank you both, it solved my problem.
  8. rtoguchi

    Help with conditional sums in Access Reports

    The problem with that is I can't summarize by the "Y/N" because they are text and not numeric fields. By doing summary in the reports, I get a sum for all pieces of "StyleA." I am looking to create a Sum for all pieces of "StyleA with Y" and a Sum for all pieces...
  9. rtoguchi

    Help with conditional sums in Access Reports

    Could anyone please help with the above mentioned problem? I am looking for the right expression to create the Sum totals. TableA TableB TableC StyleA 5 Y StyleA 5 Y StyleA 5 N Sum:"StyleA=Y"10 Sum:"StyleA=N" 5

Part and Inventory Search

Back
Top