Search results

Thanks for the education re: cross-posting Alan. Definitely no intention to upset the readers. I was guilty of looking to maximize the audience after a delay in feedback. My apologies. I iwll update my other forum post with the URL and direct responses back here. Thanks for setting me down...

CROSSTAB QUERY: Multi List Box plus other Form criteria Per the post above, what would the proper SQL "Where" criteria look like to pull the multi-list box selections from the form into a crosstab query? Is there anyway to automatically populate the selections from the list box for use with...

Paul's suggestions worked wonders for the multi-field filtering (including a multi list box) and display on the form. I have a command button that should take the results from the form display and convert it via a crosstab query into an xls file. So my new question is what is the proper...

That did the trick Paul. Thank you so much for your support (and patience). Jeff

Thanks Paul. I may be in way over my head here but I intentionally omitted that part of the event procedure as it was tied to report generation. In my form, the inputs create the filter to generate a subquery. I then have an event procedure which opens a crosstab query as an xls export based...

I have created a form that enables a subquery display and report generation. The outputs are based on the option of a single through multiple criteria inputs (query records based on city, zip code, date range, etc.). I was recently asked to enable the selection of multiple cities, so logically...

Hi forum friends, My name is Jeff and I currently reside in Dallas, TX. I have been toying with Access since 1995 and got my first job out of school thanks to some lessons learned as I immersed myself in all things MS Access and Windows 95 (fun times). I still enjoy the challenge of database...