Recent content by UPS_HPA

I finally figured out how to plug the code in to a query so I could see what it came up with. Alas, I already have a query that counts applications per applicant. I also have a query that counts total applications for the year. (I like the option to enter the name I am looking for though -...

Okay, At the risk of sounding even dumber than Access usually makes me feel, how do I implement your elegant-looking solution? :confused: I can concoct a query in "Design" view; I don't know how to do it any other way. Thanks in advance, UPS_HPA

Greetings. My database tracks applicants to certain programs, showing which year they applied, which program they applied to, whether they got in, and so on. Each person has a unique ID number. Each person may apply to multiple programs, and may apply in multiple years. I have a query that...

I had not tried that before. I didn't think it was going to work, but once I made the subreport wide enough to accommodate two columns, it did. (Hooray!!) Thank you! -UPS_HPA

I have created a subreport that prints a long list of names. Is there a simple way to force the list into multiple columns so I can make a more sensible page layout in the printed report? Thanks in advance for any help you can offer me. -UPS_HPA