Hi Phil
Thanks, I'll try it and get back to you.
Mike
MikeE1652
Last Activity: Sep 30 '16, 10:43 AM
Joined: Mar 14 '16
Location:
-
How to Select the Highest Number or Date
I have two table in MS Access, Bids and Remarks the are linked by a BidID One-to-Many. Bids have no duplicated. Remarks has many duplicates.
I want to select a BidID in Bids tables and only the highest (newest) remark to that Bid by the newest RemDate or RemID.
Bids Table Remarks Table
BidID -------------> BidID
Bid Name RemID
Customer Name RemDate
Bid Manager... -
MikeE1652 started a topic MS Access VBA OpenReport on screen does not use Grouphead0 and run Select Casein AccessMS Access VBA OpenReport on screen does not use Grouphead0 and run Select Case
I have a report that I want to open on Screen (OpenReport) and use a links to open the main form of the Details per Record.
This works well, however I use a Select CASE in my GroupHeader0, which groups the data - This seems to be bypassed.
But if I open it as a Report Print Preview the select CASE works.
How can I remedy this?
No activity results to display
Leave a comment: