Help me figure out how to make a pretty report.

April 4, 2006 11:36 AM

Access DB Filter: Help me figure out how to make a pretty report.

For the life of me I can't format a report in Access. I can edit SQL, write VBA, and generally have the program jump through hoops for me until I want a report. Even using the wizard my reports look like crap.

Expression Filter is also giving me fits. For example using =Sum([CountOfCarton]) produces errors instead of summing the carton field of the query for me. Yet when I try the same formula on a different DB (designed by someone else) it'll work. I'm at my wit's end.

posted by nulledge to Computers & Internet (3 answers total)

Can you post an image of how your report looks now?
posted by junesix at 11:45 AM on April 4, 2006

You don't mention what version you're using but Access reports can be fussy crybabies to work with regardless of version (my opinion, and I've built a lot of the things). I tend to start with the wizard and then jump straight to design view to start fiddling with it. The newsgroup microsoft.public.access.reports is pretty active and I've had a lot of luck searching for specific problems there.

My email's in my profile if you'd like me to have a look and maybe offer some ideas.
posted by NsJen at 4:55 PM on April 4, 2006

What do you mean by looks like crap? Like you can't move the filed around? Or you can't get it to show what you want?
posted by radioamy at 6:33 PM on April 4, 2006