IIf Statement

[silverxx12]

Hi i have a query output which i have sorted ascending based on the name - so that it looks something like this



order name amount

bag bill 1000
figs bob 2000


is it possible to create another column which would do the following:

In the column of name if the current cell had the same name as the one above it then blank the data cell if it was different to equal current cell

so in excel it would look like IF(B19=B18,"",B19) just not sure how to do this in access ?

[recyan]

Till some one comes along :
Say you have :
order name amount
bag bill 1000
sack bill 2000
figs bob 2000

If I have understood correctly, is below what you want done in query ?

order name amount name_1
bag bill 1000 bill
sack bill 2000
figs bob 2000 bob

If Yes, can I request to know, why?

Thanks

[silverxx12]

exactly - i need to output the data in that format ... just do what im told :-s

[recyan]

Currently, I can't think of how to do it in a query.
But, if I am not wrong, these kind of things are handled in Reports along with Grouping ( in this case Group on Name).
Just, hold on till some one comes along.

Thanks

[ssanfu]

I went through this struggle years ago when I was trying to create a "milage" database to track fuel usage for my vehicles.

First, read this thread, especially the posts from The Doc Man.
http://www.access-programmers.co.uk/...d.php?t=130382

Then see this thread.
http://www.access-programmers.co.uk/...ad.php?t=27545

These will give you more info on "Previous Record" in the context of a recordset.
Post back with questions........


PS: I had a dateFilledUp field and an Odometer field that I could us (either field) to "Sort" the recordset, assuming I filled up only once in a day per vehicle. You will need a unique field to be able to sort (order) the records.