By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,728 Members | 2,414 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,728 IT Pros & Developers. It's quick & easy.

Combine multiple records into one

P: n/a
I have a table with multiple records in it. I am being forced to
combine multiple records into one record in order to be uploaded to a
website, and I only get one record per client. How can I
systematically combine multiple records into 1?

The table looks like this

Client ID Service Status
1 Doc Pending
1 Test Pending
1 Fix Complete
2 Fix Pending
2 Other Complete
3 Doc Complete
3 Test Complete
3 AA Complete
3 Mail Pending

I need 1 record for Client 1, one for Client 2, one for Client 3.

Any suggestions?

Thanks in advance,
Laura

Feb 27 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
musicloverlch wrote:
I have a table with multiple records in it. I am being forced to
combine multiple records into one record in order to be uploaded to a
website, and I only get one record per client. How can I
systematically combine multiple records into 1?

The table looks like this

Client ID Service Status
1 Doc Pending
1 Test Pending
1 Fix Complete
2 Fix Pending
2 Other Complete
3 Doc Complete
3 Test Complete
3 AA Complete
3 Mail Pending

I need 1 record for Client 1, one for Client 2, one for Client 3.


Use VBA to concatenate the records into one string.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Feb 27 '06 #2

P: n/a
I tried the Module available for doing this at the AccessWeb site below
(using Access 2000)

http://www.mvps.org/access/modules/mdl0008.htm

but, unfortunately, I get either a "Complie Error: User-defined type
not defined".

I really need something similar myself, but can't figure out what I
need to fix.

Tino

Feb 28 '06 #3

P: n/a
See:
http://www.mvps.org/access/bugs/bugs0031.htm
Bugs: Access 2000: Type Mismatch or User Defined Type Not Defined
Author(s)
Dev Ashish
When you create a new database in Access 2000, the default data
access library used is ADO. That is, ADO will be selected under
Tools/References in VBE instead of DAO. Converted databases still retain DAO
as the default library and ADO will not be selected under References.
The "Type Mismatch" error occurs as the global class Recordset is
evaluated as ADODB.Recordset instead of the DAO.Recordset, while the "User
Defined Type Not Defined" error is generated at compile time because there
is no Database object in ADO.

To fix this problem, uncheck the ADO reference and check DAO 3.6
Library as a new reference.

You may still receive this error message when referring to DAO
Recordsets if you have both ADO and DAO selected under References. This is
because the ADO reference is listed above DAO in the References dialog and
hence, is taking precedence at runtime when Access tries to resolve your
data types. To move the DAO reference above the ADO one in the dialog,

a.. Uncheck the ADO reference.
b.. Close the References dialog.
c.. Open the dialog again.
d.. Check the ADO reference.
e.. Close the dialog.
If you are working with a database in which both ADO and DAO
references are selected, the best way is to always fully qualify your data
types. For example:

Dim rsCustomers as ADODB.Recordset
Dim rsInvoices as DAO.Recordset

For more details on which references to use in your application, view
this article.

Article ID: 197110
ACC2000: References to Set When Working with Microsoft Access

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
<Ti*****@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...
I tried the Module available for doing this at the AccessWeb site below
(using Access 2000)

http://www.mvps.org/access/modules/mdl0008.htm

but, unfortunately, I get either a "Complie Error: User-defined type
not defined".

I really need something similar myself, but can't figure out what I
need to fix.

Tino

Feb 28 '06 #4

P: n/a
Stephen,

You are an answer to my prayers!!
no
It works perfectly now.

Thanks!
Ti

Feb 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.