L
Linda RQ
Hi Everyone,
I have a query in Access 2003 and I want to only show the records from my
ThpyEndDtTm field that are the most recent. I think I need to use the DLast
function and I have been trying to learn to use the builder tool since I
took a class and they were using this. I was able to follow along well in
class but couldn't get the notes too, it seemed easy at the time <g> but the
teacher knew exactly what needed to be in the parentheses and what didn't.
Here is where I am at.....In my query grid, I R click on my field
ThpyEndDtTm and select build. I then click on the built in functions and
navigate to the DLast function. When I double click that, I get this
ThpyEndDtTm «Expr» DLast («expr», «domain», «criteria»)
I think I am supposed to delete this <<Expr>> and cut the ThpyEndDtTm and
paste it in here..... <<expr>>. I don't know what to do with domain or
criteria. I tried several variations and get "not enough argument" errors
and other various errors and thrashings.
Thanks,
Linda
I have a query in Access 2003 and I want to only show the records from my
ThpyEndDtTm field that are the most recent. I think I need to use the DLast
function and I have been trying to learn to use the builder tool since I
took a class and they were using this. I was able to follow along well in
class but couldn't get the notes too, it seemed easy at the time <g> but the
teacher knew exactly what needed to be in the parentheses and what didn't.
Here is where I am at.....In my query grid, I R click on my field
ThpyEndDtTm and select build. I then click on the built in functions and
navigate to the DLast function. When I double click that, I get this
ThpyEndDtTm «Expr» DLast («expr», «domain», «criteria»)
I think I am supposed to delete this <<Expr>> and cut the ThpyEndDtTm and
paste it in here..... <<expr>>. I don't know what to do with domain or
criteria. I tried several variations and get "not enough argument" errors
and other various errors and thrashings.
Thanks,
Linda