From: klp via AccessMonster.com on 26 Apr 2010 10:58 I have a crosstab query that puts the day of week but I would like it to put each day, Monday thru Friday even if there is no data. How do I accomplish this? Thanks! Kim P -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1
From: Jerry Whittle on 26 Apr 2010 12:15 Easy! Open the crosstab query in design view; right click in the area near the tables; and select Properties. Next go into the Column Headings and put in something like: 'Monday,'Tuesday','Wednesday','Thursday','Friday' Note: The above will prevent Saturday or Sunday from showing up even if there is data for them. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "klp via AccessMonster.com" wrote: > I have a crosstab query that puts the day of week but I would like it to put > each day, Monday thru Friday even if there is no data. How do I accomplish > this? > > Thanks! > Kim P > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1 > > . >
From: klp via AccessMonster.com on 26 Apr 2010 12:19 Fabulous! How easy is that! Thank you!!! Jerry Whittle wrote: >Easy! Open the crosstab query in design view; right click in the area near >the tables; and select Properties. Next go into the Column Headings and put >in something like: > >'Monday,'Tuesday','Wednesday','Thursday','Friday' > >Note: The above will prevent Saturday or Sunday from showing up even if >there is data for them. >> I have a crosstab query that puts the day of week but I would like it to put >> each day, Monday thru Friday even if there is no data. How do I accomplish >> this? >> >> Thanks! >> Kim P -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1
|
Pages: 1 Prev: Search for current date in a text field Next: Query 90 expiration |