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 TouchToneTommy 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: 60myles
  • Content: Threads
  • Order by date
  1. 60myles

    My Update Query Loses Currency Format

    I have written the following Query - SELECT Transactions.TransactionNumber, Transactions.TransactionDate, Transactions.TransactionDescription, Transactions.WithdrawalAmount, Transactions.DepositAmount FROM Transactions WHERE (((Transactions.TransactionDate) Between [Forms]![Report Date...
  2. 60myles

    How do I link the Report Date Range Form to my report?

    The Wizard which sets up the ledger Database system has a nifty "Report Data Range" form on one of the generated reports. I copied it to my database forms, and put the VBA code into the report code. The form pops up OK and gets the dates, which appear on the report line {="For...
  3. 60myles

    How to find Unpaid Fees

    I am developing a Condominium system - one of the modules tracks Quarterly Maintenance Fee payments. Link is to the ROSTER table by Unit #. How do I find Unpaid Maintenance Fees from the Maintenance Fee table, using a simple(?) query(ies)? I have tried Union Queries, Append Queries, Make table...

Part and Inventory Search

Back
Top