Trying to Condense (1 Viewer)

[Castaway]

Well not sure how to phrase it but let me show you what I have....
Ex.
I have it grouped by the Street Name

House_to House_from Side City
2100 2198 E La Verne
2101 2199 O La Verne
2200 2298 E La Verne
2201 2299 O La Verne
And so on...

The thing is that I want it to read like this instead of the way the above looks...

2100 2199 B La Verne
2200 2299 B La Verne
Where E is Even, O is Odd and B is Both.

I am looking for any help from being a table, query, or report problem. I'll take any suggestions. I did ask this question before and like to thank you for the help the only thing is that it reads nothing but E. Thanks

 

[llkhoutx]

I think that you going to have to loop through your data (recordset) with DAO code to build the various codes that you want.

 

[Castaway]

Not sure what you are talking about, Can you explain it.

 

[pdx_man]

Castaway, I never got a reply from the last email I sent you. That code that I sent you will work, I tested it myself.
One place that it can be called from is a column in a query.
Create a new column:
Side: OddEven(HouseTo,HouseFrom)

Base your report on this query

I emailed you the sample I created.

[This message has been edited by pdx_man (edited 03-06-2001).]

 

[Castaway]

Thanks PDX....I got your E mail and I see how it works but I have a little different question. I am going to Email you a little sample of what I am trying to get. Please E mail me if you don't get it. Thanks for all the help. NC