Crosstab Queries - Year wise query in Sequence without Skipping Years having no Data! (1 Viewer)

Hi everyone, please help me in making a dynamic query with yearwise column heading, i want to show the column years in sequence, if there is no data for any year ms-access is skipping that year from the query column heading, i want ms-access to dont disturb the sequence and show the column head with blank data (if there is no data). Please review the attachment of query required. Waiting for your kind response, any idea or help? Thanks

Check out http://allenbrowne.com/ser-67.html

You need to set the column properties shown about half way down the article.

In query design view, show the Properties box (View menu.)

Locate the Column Headings property. (If you don't see it, you are looking at the properties of a field instead of the properties of the query.)

Type in all the possible values, separated by commas. Delimit text values with quotes, or date values with #.