MS Access SQL: >1 querry results in one cell

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
MS Access SQL: >1 querry results in one cell

Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

November 23rd, 2004, 06:14 AM

pav

Registered User

Join Date: Nov 2004

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

MS Access SQL: >1 querry results in one cell

I am searching a database and want to get all the values from a drop-down box into one cell when I build the SQL SELECT statement, i.e. I want to select various things, as well as values from this box, but I don't want 20 rows generated if there are 20 values in the drop-down box, I'd like one row, with all the values (which are accessed like anything else from individual cells in a column in a table) in one cell.
Any ideas? Thanks...

Pav

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Migration from MS Access -> MySql	spraveens	MySQL	3	March 6th, 2010 04:45 AM
ASP with MS Access unique ID AA00 -> ZZ99	sv3n1980	Access ASP	0	May 9th, 2007 08:11 AM
Database migration MS Access 2003 to MS SQL 2000	ayazhoda	SQL Server 2000	3	April 23rd, 2007 11:38 AM
MS ACCESS 2003 FRONTEND AND MS SQL SERVER 2005 DB	mohankumar0709	SQL Server 2005	3	March 23rd, 2007 12:48 AM
MS Access ----> MS Word	anukagni	Access	1	August 30th, 2006 02:15 AM