Access Query

I

Ian Brooks

Hi Everyone,

Can someone tell me how, using query preferably, I can achieve the following:

I have a table that has a list of values in one field, example:

Field 1
GBR
GBR
GBR
IRL
IRL
IRL

What I need to do is put a flag in another column to indicate the end of a
section so it would look like this:

Field 1 Field 2
GBR
GBR
GBR ***
IRL
IRL
IRL ***

Some know how I can do this?

Thanks very much for your help.
 
B

Bob I

Depending on the "SORT" your idea for "field2" will be rendered invalid.
You can't think of a selection of simular records as a "section" or as
having a "begining" or "end".
 
I

Ian Brooks

Thanks Bob, I understand that, what I was actually after was the 'code' that
would compare the current content of a field to the previous content and take
appropriate action. I'll worry about keeping them in output order if you can
give me the code.

Thanks
 
B

Bob I

That's EXACTLY the issue. There is no "PREVIOUS CONTENT", records are
records. There is ABSOLUTELY NO "before or after", they are individual
entries, and have no intrinsic order. The best you can do is "display in
groups" in a report.
 
Top