I have a library database that contains two tables. Master table with library contents and a usage table listing each time something is used.
I want to create a report that lists all library entries and only the last time it was used. Some library entries have not been used but I want to show them on the list anyway.
Book 1 used 1/1/11, 1/15/11 and 3/20/11
Book 2 never used
Book 3 used 10/1/11, 9/15/11 and 7/23/11
Book 1 3/20/11
Book 3 10/1/11
I can get a complete listing with all usage dates. But I only want to see the most recent one. I've tried creating a query on the usage table listing the library entry ascending and usage date descending -- then tried to create a bound control on the report with a Dlookup -- but that didn't work.
Thanks for your help,