R
Ram Praveen
Want to understand more on creating Loop syntax inMsaccess.
Want to understand transpose tabel data in Msaccess
Want to understand transpose tabel data in Msaccess
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Michel Walsh
The LOOP syntax is a VBA syntax. There is no loop, by itself, in SQL. In
SQL, you describe the result you want, not HOW to get it.
You cannot transpose a table, in general, since you are limited to 255
fields, and are unlimited, vertically.
You can use a CROSSTAB query to de-normalize the data, supplying then a
'rectangular' view of your data, which is easier to read, for a human
being.
You can use a UNION query to re-normalize the data, from a crosstab, if
required, to get a more acceptable normalized data, easier to do
computation/search/filter.
Vanderghast, Access MVP
SQL, you describe the result you want, not HOW to get it.
You cannot transpose a table, in general, since you are limited to 255
fields, and are unlimited, vertically.
You can use a CROSSTAB query to de-normalize the data, supplying then a
'rectangular' view of your data, which is easier to read, for a human
being.
You can use a UNION query to re-normalize the data, from a crosstab, if
required, to get a more acceptable normalized data, easier to do
computation/search/filter.
Vanderghast, Access MVP