dmax

Hello, I am trying to create a calculated field in my query to display the most recent receive date (other than the current OrderID) for a material and serial. Below is my table1 example: <tbody> ORDERID MATERIAL SERIAL NUMBER CREATE DATE RECEIVE DATE A5 C123 412 1/1/2017 3/3/2017 A4...

Hello, I am trying to determine that latest Dates that occur next to a specific Name. Here is the formula that I am using: {=MAX(IF(POs!AB:AB=A2,POs!AC:AC))} whereas: POs!AB:AB is a spreadsheet range of Names A2 is one specific Name that I want to find the latest corresponding Date POs!AC:AC...

Hi all I have a problem that I’m stuck with and I cannot for the life of me come up with a formula that works! I have a data set that is duplicating on ID number as there is more than one expiry date per ID. I’m after a formula that would look up each ID number in column A but bring back the...

I need help finding the next highest values for one month. I used the Dmax function to return the highest value but I still need to extract at least the 5 next ones. Any idea? Thx.

I am sure this is fairly simple but I am having trouble getting started on this. I use a Form to invoice clients which includes the field [Billing_Month]. What I'm looking to accomplish is this. When I create a new invoice and enter the [cboAccountID] value, the [Billing_Month] field will...

Hi guys, I'm wondering whether its possible to set up the selection criteria relating to a databse formula horizontally (i.e. in cells A1 and B1) rather than vertically (in cells A1 and A2)? It would be very helpful for my model given my dsum / dmax formulas run down a page (so at the moment...

Hi, I am using Dmax, Dsum formulas to sum the values (in column A) associated with a given serial number (where the serial numbers are in columns B, C,......). The strange outcome I get is that for a given serial number "UMC1", my summed values include those associated with serial number UMC1...

Hello all, I'm attempting to convert a "multiple criteria" Lotus 123 @DMAX function to a "multiple criteria" Excel =DMAX function. I've received some assistance but it did not solve the problem. Thank you for the help. Does anyone out there have data base experience using the =DMAX function...