var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: New to access requesting help
I am just new to using access and I am having a bit of difficulty with limiting a search to the details at the last entered date. I have the following table:
TestID - Autonumber
Name - text
Date - Date/Time
Amount - Number
I entered the following data" two different names (Bill and Tim) with two different dates and amounts for each name. So 4 records in total.
when I run a query just projecting the name and date, I retrieve all 4 records. When I select, Max on the date, I only retrieve the most recent two records.
When I then project the Amount into the query, and keep the max on date, I retrieve all 4 records again! I only want the latest two, with the amount data for those records.
What do I have to do to achieve this?
Here is some SQL for you ive struggled to reproduce what you did
but have done this problem how i would of approached it
Is this any help
SELECT tblTest.Name, tblTest.Date, tblTest.Amount
WHERE tblTest.Date IN (select Max([Date]) From tblTest);
You made it look so easy. Fantastic.