UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Displaying The Last Date Issued For The Items , Query -, Access 2007    
 
   
phil_andre
post Dec 8 2017, 02:15 AM
Post#1



Posts: 212
Joined: 7-December 16



Hi Support,

Please need your kind support below requirements.


1. Need a query to display the last date issued for the specific item in each details like.

Example i have transation with 5 lines for code no. CD0001 that should display in query like this in expression / unbound query if possible for indicating the last date issued.

CD0001 - issued date 28/11/2017 and last issued date 25/11/2017
CD0001 - issued date 01/12/2017 and last issued date 28/11/2017
CD0001 - issued date 05/12/2017 and last issued date 01/12/2017
CD0001 - issued date 06/11/2017 and last issued date 05/12/2017
CD0001 - issued date 13/12/2017 and last issued date 06/12/2017


Thanks in advance.
Go to the top of the page
 
MadPiet
post Dec 8 2017, 02:41 AM
Post#2



Posts: 2,426
Joined: 27-February 09



You would have to create a totals query and grab the last date for each ItemID (or whatever that number represents). Then you could join that back to the original query, (in a new query), and you'd be all set.

Otherwise, you could use a DMAX() and use the ItemID of the current record to get the latest date.
Go to the top of the page
 
phil_andre
post Dec 8 2017, 03:13 AM
Post#3



Posts: 212
Joined: 7-December 16



Thanks Mad.

Can you please do me a favour if you can give an SQL sample or upload and small table would be much appreciated.
This post has been edited by phil_andre: Dec 8 2017, 03:14 AM
Go to the top of the page
 
phil_andre
post Dec 8 2017, 03:44 AM
Post#4



Posts: 212
Joined: 7-December 16



Dear Mad,

Please find attached and kindly advise.


I need to generate a report with expression field taht wud indicate the last date issued before the date on each itemID line in transaction details.

thanks.
This post has been edited by phil_andre: Dec 8 2017, 03:49 AM
Attached File(s)
Attached File  Phil_Sample.zip ( 29.9K )Number of downloads: 3
 
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th July 2018 - 06:30 PM