Combining data into a single field

[cheftim]

REPOST from Design Area

Hello all,

I hope that the following explination of my problem in clear...

I have a table with a series of dates in individual fields: Day1, Day2, etc.

What I would like to do now is to combine those into another query/table where the dates are all in one field.

ie:
Original Table
[Day1] March 1
[Day2] March 2
[Day3] March 3

New Table
[Date] March 1, March 2, March 3.

Can you help me figure out how to accomplish this? I greatly appreciate your time and sharing of any thoughts that you have on this situation.

t

 

[johndoomed]

Update queries if you want to do this with many records at once.

VBA if you want to do this one record at a time.

 

[The_Doc_Man]

Cheftim, the biggest problem with doing this is that you are asking Access to go in the "wrong" direction. If you had showed us that second line first, we would have jumped on your stuff for normalization issues. As it stands, your first display is correct for records.

The question for how to do the effect you want easiest depends on what is going to be on the next line of that display. Before we take a more targeted shot at a solution, we need to see the target, not just a general description of it.

I'll tip my hand a bit...

In one case, the answer MIGHT be a crosstab query. In another case, john's answer "VBA" might be right. So my immediate answer is "not enough info."

Like Emeril, you have to kick up your descriptions just one more notch (>>>bam<<<) before we can give you best advice. Don't go overboard on details, but we need to know at least a little about where you are going.

 

[cheftim]

Thanks, Doc.

I was trying to simplify so that I did not waste your time with extraneous info... maybe I tunicated my description too much.

I recieve a start date for an event and the number of days that it will last.
I need to schedule meals and buildings/rooms for each day of the event so I created a query that will create a table with the calculated dates for each day of the event. (Our events never last more than 15 days so I was able to create a series of 15 date fields in the query.)

I will need to eventually use these dates in query with the meal counts for each group and the building usage, etc.

I hope this shed's some light on things.

Tim

 

[cheftim]

Please see the posts in the "Design" forum for my results. Thanks to everyone who helped.