LastRecord

[Shakeel Ahmad]

I have a query to enter monthly fees of studests

FeeID
FeeMonth
FeeYear
FeeAmount

I want to make another query and set its criteria to show only the:
Last Entry
Or the Greatest number of Autonumbers (FeeID)

plz help

Shakeel Ahmad.

 

[Guest]

You could use: Select Top 1 FeeID From "queryname" Desc

hth

 

[Arvin Meyer [MVP]]

SELECT TOP 1 tblFees.*
FROM tblFees
ORDER BY FeeID DESC;

 

[Shakeel Ahmad]

Sorry, I could not use this method. Where should i enter this code?
I want to make a query and use this method in critera but when i enter this
code into criteria box, it does't work. it gives an error

plz explain....

Thanks and Regards