LAST ITEM won't appear

SBBmaster09

Registered User.
Local time
Today, 18:27
Joined
Apr 26, 2013
Messages
92
I have a query table from a main table. It has different fields. I am having problem with my table.

I have a ProjectNum Total to GroupBy and the remaining fields are total to "Last". The problem is according to the main table the last production is 6/17 but the data the query table is getting is not the last but the 2nd to the last.

How could i resolve it to get the very last data inputted, it is not reading the very last one in the table. Is there a code or something like other stuffs to do? Thanks.

It has eaten my whole day resolving it. Thanks.
 
I am unable to follow you.. :confused:

Can you show a screenshot or something? Or maybe give another shot at explaining?
 
Use Max rather than Last. You want the date with the highest value NOT the last date in the recordset which could be any date value.
 
I tried using MAX but still it won't display the last item it had entered the database.



This is an example of the item i am looking.
The MainTable shows almost 8 items

MainTable.png

The QueryTable should display the very last item that it will see.. but id doesnt display it..
qryTable.png

This is the design view of the querytable.. I also tried using MAX but still it wont change..
qryTable_DesignView.png


Its all I can give for now to show the problem.. Thanks,
 
That is not how an aggregate query is done.

Start with a query that includes only the fields you want to Group By plus a field that can designate the "last" entry by returning the Max as well as the key (presumably Transaction).

Then use this query joined by the key to the original table to return the rest of the fields you require.

Do not use Last. It isn't what you think.
 
You are not showing all fields in the picture of the table, so it will only be a guess, does the value of field "SystemUsed"="Castro"?
If yes, then the query returning exactly what you're asking for.
Can't you use the value of "Transaction"
 
Can you explain it further by step by steps on how will i do it.. I'm still confused on how to make it the right way that you have suggested. Thanks.
 
That is not how an aggregate query is done.

Start with a query that includes only the fields you want to Group By plus a field that can designate the "last" entry by returning the Max as well as the key (presumably Transaction).

Then use this query joined by the key to the original table to return the rest of the fields you require.

Do not use Last. It isn't what you think.

Can you explain it further by step by steps on how will i do it.. I'm still confused on how to make it the right way that you have suggested. Thanks.
 
Ive done it.

You have to create another query where the contents will be the grp fields and the MAX. Then connect that query into your table. the best way is to connect with the TransId. and thats it.

This info is for future reference. I will now closed this thread.
 

Users who are viewing this thread

Back
Top Bottom