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!

Search results for query: *

  1. 60myles

    My Update Query Loses Currency Format

    Well, I figured it out. I made a one record, one (empty) field, currency format, table, and rewrote my query as follows: SELECT Transactions.TransactionID, Transactions.TransactionNumber, Transactions.TransactionDate, Transactions.TransactionDescription, Transactions.WithdrawalAmount...
  2. 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...
  3. 60myles

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

    Yes, Yes, Yes - Thank you Jane, I typed this in to my Form code (so I could almost figure out what it was doing), changed the file names appropriately, and it works! - And Bill, thanks for your help - this post worked so I'm now happy! :-D
  4. 60myles

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

    I think I get it - I'm just going to insert that code into the query instead of [What is Beginning Date] and [What is ending date] - Makes sense - I'll try it and feed back the results!
  5. 60myles

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

    Well, thanks for the suggestions - I'm not running this particular report from a query, as the report in the Ledger Sample doesn't seem to - In order to make mine work, I wrote a query, which worked OK, but with the query I lost the Form. I like the cosmetic aspect of the form, and I suppose...
  6. 60myles

    Blank Pages When Viewing and Printing Reports

    I have found that sometimes there are lines (as in ruled lines) that, unnoticed, stretch slightly (or a lot!) beyond the edge of the page. You could double check these as well.
  7. 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...
  8. 60myles

    How to find Unpaid Fees

    I think I have it figured out - I have to make 2 queries. First is to make a temporary table [T2] for Maintenance Fees for the quarter, then make a "find unmatched records" query on [T2] and the ROSTER table. Otherwise the Maintenance Fees table has several "hits" on each...
  9. 60myles

    How to find Unpaid Fees

    Well, my ROSTER table is a pretty much fixed list of all the Condos with their owners, adresses, phones, etc. the parts which change if a unit is sold, i. e. the Maintenance Fees is YEAR, UNIT (linked to ROSTER.Unit#), Deposit#, Quarter, Check Date, Check#, Payment, [Late Fees], [Date Posted]...
  10. 60myles

    How to find Unpaid Fees

    Well, this is weird - I typed in the code exactly as you gave it (substituting my field names, of course), and tried all sorts of variations from there, my "Join Properties" are 2: Include All from ROSTER and only those from MaintFees... and my SQL reads: SELECT DISTINCTROW...
  11. 60myles

    How to find Unpaid Fees

    OK - I found it in the "Help" topics - let me give it a try and work on it further - thanks for your help.
  12. 60myles

    How to find Unpaid Fees

    Thanks for your reply - I'm using Access 2000. but I don't find any "find unmatched records" criteria ?? :-(
  13. 60myles

    How to find Unpaid Fees

    It should be quite simple - one table has all the Units (ROSTER) and one table might not ([Maintenance Fees]) WHILE Quarter = [Which Quarter?] - I need to find the missing ones, if any! But...B-(
  14. 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