Search results for query: *

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

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

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

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!

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

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.

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

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

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

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

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

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

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

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