Search results

nil valuesa are fine as long as the headings are there - reason being, the report that is generated is a sub report of a bigger, greater, stronger, prettier, fuller-figured, mega-super-duper-wooper report........and i need the headings to line up :o thats cool though, nil values are fine, i...

no! IT WORKS!!!!!!!!!!!!!!!!! :D:D:D:D:D:D hmmmm, must have bin me being an idiot......[big sigh].....that has saved me a lot of bodging, fudging, hacking, stressing, explaining, crying, screaming, slapping, sweating and s##tting!!! cheers guys

ha, strange that you should post that literally 10 seconds after i stumbled upon it whilst searching through the properties.....however.....it gives the headings I want/need, but doesnt display any data! so i can have data without headings....and headings without data.......maybe i should just...

Is there any way a crosstab query will display a full table even if there are limited records. i.e. for a table that holds actions submitted to a certain department - where actions were submitted on mon, tues, wed, fri, sat, but not thursday or sunday at the moment the crosstab will look...

I'm having exactly the same problem....this is the first time, however, i've heard anyone say it may be because of the difference in date formats (I am a UK Access user) - i've tried all ways around the problem that have seen posted across hundreds of threads now but nothing works. pbaldy, i...