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

Assistance with Query to Consolidate Records

P: n/a
Trying to determine the best approach to use in consolating multiple
records in an Access 97 Db. The users submit updates in HTML format
generated from a query that are in turn imported into a master
database. There are 50+/- records each that are submitted by a
substantial number of users with each periodic update. The output does
include the user ID reference and the date prepared, but as a query
has no header, the information is included on each row - or can a
query have a header when used as HTML output?

Simply, I need to consolidate all data provided and imported by user
ID, name and date of submission and nothing else, and which can be
viewed as a single, consolidated line. Any suggestions on
implementation will be appreciated. Thanks, Dalan
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Search accessweb for fConcatChild. Play with that a little bit and it
should give you what you want. You may need to tweak it to collect
data from more columns, though.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.