Search results for query: *

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).

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...

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...

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...

Thank You, it definitely solved the problem.

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"?

Thank you both, it solved my problem.

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...

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