Hi
I need to create a field expression to evaluate two fields from a prior record but I'm not sure how to do it. I have a table with fields including dollar amounts and dates. I can Desc sort on dollars and then dates, and need a 3rd field that evaluates the preceeding dollar and date against the currect record's dollar and date values. If they are the same, the results should return a "Y", else a "n". Qry results would look like this:
Amount Date Flag
100 1/1/2009
120 1/15/2009 "N"
120 1/15/2009 "Y"
Is there an easy way to even do this in an access query? I have to resort to an xls spreadsheet. Thanks
I need to create a field expression to evaluate two fields from a prior record but I'm not sure how to do it. I have a table with fields including dollar amounts and dates. I can Desc sort on dollars and then dates, and need a 3rd field that evaluates the preceeding dollar and date against the currect record's dollar and date values. If they are the same, the results should return a "Y", else a "n". Qry results would look like this:
Amount Date Flag
100 1/1/2009
120 1/15/2009 "N"
120 1/15/2009 "Y"
Is there an easy way to even do this in an access query? I have to resort to an xls spreadsheet. Thanks