Continuous Form Data to Report - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Continuous Form Data to Report

Derek Kirkman

4 years ago

Hi, I have a continuous form that feeds into a report. If the continuous form (CF) only has one line of data, I can get the specific piece to show in the textbox of the report. However, if I have two or more lines in the CF, I don't know how to get those additional pieced to go from a CF vertical data set to a concatenated, separated by a coma, horizonal readout on the report. Do you know how I could do this?
Thanks for any possible help!
Example
Continuous Form Entry
PK1 ID1 AccNo1A Amount
PK4 ID1 AccNoB4 Amount
PK9 ID1 AccNo38 Amount

Report Textbox
AccNo1A, AccNoB4, AccNo38

	Scott Axton @Reply 4 years ago
I suggest you go back to Beginner 1 Particularly re-watch Lesson 12. BTW continuous forms don't feed into Reports. I see that you went right from Beginner 2 directly to the Developer level. You missed tons of instruction on how to work with Access. You are best getting the basics down first.

	Richard Rost @Reply 4 years ago
You could do that with columns in your report. Access Expert 7.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View