calc Max query problem

[HOTLIPS]

Hi
Can anyone help
I have a table of Equipment Items... these items have a holder and a location.. and the table is a history table containing a record of the date, the new holder and new location.. everytime the item changed holder and location.....
My problem is I want to select the last date the item was transferred and the particular holder and location of that last date.
I would like to do it in 1 query....as the answer is an inmemory tcursor
Table fields
EqNo Eqtype TransferDate Holder location
Thanks
Hotlips

 

[footpad]

Hotlips,

Instead of returning Date, replace the checkmark with MAX. that should return the latest holder and location for the item(s) you're selecting.

Hope this helps...

-- Lance

 

[HOTLIPS]

Thanks Lance.........
........but I need the EqNo Eqtype the last date and the holder name and location at that last date......
any suggestions ???..... could it be done using SQL in paradox?????
Thanks hotlips

 

[SercoSteve]

I may have misunderstood the problem but wouldn't the following query do the job. 'No' is a variable containing the item of interest.

Query
ANSWER: RIV:ANSWER.DB

SORT: RIV:testing.db->"TransferDate", RIV:testing.db->"EqNo",
RIV:testing.db->"EqType", RIV:testing.db->"Holder", RIV:testing.db->"Location"

RIV:testing.db | EqNo | EqType | TransferDate | Holder | Location |
| Check ~No | Check | Check | Check | Check |

EndQuery

The record of interest should be the last in RIV:ANSWER.DB.

Steve