And with my test data fixed, everyone's code works now! Yay! Now to go study the code and figure out why it works and how to use it...

Luke L (9/27/2010)[/b

It looks like you spelled the street address 2 different ways for Los Mules in your sample data. I never noticed the first time around.

'4971 Buriito Ave'

'4971...

Kit G (9/27/2010)

---

steve-893342 (9/27/2010)

---

Kit G (9/27/2010)

---

Thanks Steve for the code. That date at Los Mules where...

steve-893342 (9/27/2010)

---

Kit G (9/27/2010)

---

Thanks Steve for the code. That date at Los Mules where the Event...

I'm always confused... it's just a matter of degree....

Yes, I did, Wayne. Chris' is working great and so is Brandie's. Of course, now that I have it working, I get told, "Oh, that's nice, but the...

Brandie Tarvin (9/27/2010)

---

Okay, here's redone code taking into account the event date & time columns being on the same row. However, you're making an assumption that Event 1's menu will...

Chris Morris-439714 (9/27/2010)

---

Brandie Tarvin (9/27/2010)

---

Chris, your code doesn't do what he wants Menu1 and Menu2 to do.

Also, you forgot to remove the # sign from your table name. Since he's...

Brandie Tarvin (9/27/2010)

---

Kit,

Try using DatePart, DateAdd, and CharIndex in your code. It'll make your select statement a lot less messy.

select Venue as VName,

address1 as VAddr1,

city + ', '...

Thanks Steve for the code. That date at Los Mules where the Event date is the...

Luke L (9/24/2010)

---

Kit, is the sample data representative of the data in your database in so much as there is no way to differentiate the 2 events with the exception...

Thanks for the ideas, guys. I, unfortunately, didn't have the time to try them out today, but I will (I hope) on Monday. I'll let you know how...

Alvin Ramard (9/21/2010)

---

Greg Edwards-268690 (9/21/2010)

---

Excel can do anyhing, even word processing! 😛

It's kind of like I can record a macro, so I can...

No, I believe that...

Looks like Steve axed the post.

(and he hit the post button faster than me.) 🙂