<div>
Thanks - this opens up a whole load of options<br />
<br />
Regards
</div>


Thanks - this opens up a whole load of options

Regards

<div>
I just learned about UNION queries last week... &nbsp;Glad to help.
</div>


I just learned about UNION queries last week...  Glad to help.

<div>
I noticed you'd posted a question after I'd written mine re UNION generally !!<br />
<br />
Suppose my question accidentally gave an answer to yours !<br />
<br />
Regards<br />
<br />
Andrew
</div>


I noticed you'd posted a question after I'd written mine re UNION generally !!

Suppose my question accidentally gave an answer to yours !

Regards

Andrew

<div>
Well, these unions had seemed an odd creature to me, and are infrequently encountered, (or mentioned in manuals, etc.)<br />
<br />
So I posted my question to bring answers out of the woodwork. &nbsp;But they still seemed a bit useless. &nbsp;Till I saw your question, and realized that a bunch of passes through the records would really hit the spot.<br />
<br />
Answering your question is the first use that I've had from the question that I had posted.<br />
<br />
Brian
</div>


Well, these unions had seemed an odd creature to me, and are infrequently encountered, (or mentioned in manuals, etc.)

So I posted my question to bring answers out of the woodwork.  But they still seemed a bit useless.  Till I saw your question, and realized that a bunch of passes through the records would really hit the spot.

Answering your question is the first use that I've had from the question that I had posted.

Brian

<div>
<div class="content wysiwyg-content">
Imagine a table with 10 records with column headings as follows:-<br />
Expense Type; Cost Centre; Week 1; Week 2; Week 3; Week 4; Week 5<br />
<br />
Where Expense Type and Cost Centre is Narrative, and all other columns are values.<br />
<br />
Is there a simple way to convert this to a more simplistic table with 50 records with column headings as:-<br />
Expense Type; Cost Centre; Week No; Value <br />
<br />
The requirement is effectively the inverse of a crosstab query,<br />
<br />
Regards
</div>
</div>


Imagine a table with 10 records with column headings as follows:-
Expense Type; Cost Centre; Week 1; Week 2; Week 3; Week 4; Week 5

Where Expense Type and Cost Centre is Narrative, and all other columns are values.

Is there a simple way to convert this to a more simplistic table with 50 records with column headings as:-
Expense Type; Cost Centre; Week No; Value 

The requirement is effectively the inverse of a crosstab query,

Regards

How to convert a crosstab type table to flat file format

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.