Course List - Access 320

Student Interaction: Microsoft Access 320

Richard on 1/1/2008: Recordset basics, creating a recordset, moving around in recordsets, finding records.

BRYAN�binkerd on 7/1/2009: on lesson 02, first recordset time frame 0736, I understand the StatusText = S & vbnewline but I don't understand the "& StatusText" that follows the statement.

Richard Rost on 7/2/2009: Bryan, that's just to continue with whatever previous StatusText was there before. It's like saying: X = A + X It takes X, adds A to the beginning, and then whatever X was there before. It's so you can keep a long listing of continuous "status" information.

bryan binkerd on 7/3/2009: thanks for the clarification. You rock.

Richard Rost on 7/3/2009: Thanks, Bryan. I try. :)

Margaret Cattarin on 7/30/2009: Richard, I have started a db for conducting a community survey. I am having difficulty bringing the responder information, questions, responses, etc. together for a tabulated summary report. Is this something that could be accomplished with Record Sets? Thank You!

Richard Rost on 7/31/2009: Margaret, tell me more about what your report needs to look like. Have you tried a CROSSTAB query?

Margaret Cattarin on 7/31/2009: Richard, I have a Response form for each of the households that return the survey. The main form has the name and information that I need to fill in, such as #of persons in household, combined income, #Over 65 and #Under 18. The Sub form has information that I can pick from drop down boxes (gender, years at address, marital status, and comments. This is the point where I am stuck. I would really like to generate two reports. The first would list all of the survey responses sorted by household. The second needs to have the counts or sums of each response (count of male, count of female, sum of persons Over 65, Rate of Return, % Moderate Income, % Low Income, Average Income, etc.). If you can get me to that point, I think that I will be able to set the detail section of the report as not visible and then put all of the calculations in the report footer. I tried a crosstab query, but I don't know how to use this in a report. Any help you can give me will be very much appreciated.

Richard Rost on 8/3/2009: Margaret, why not just GROUP the report based on each respondent, and then put the calculations in the footer of the group? You can use the =SUM(Field) or =COUNT(Field) functions in that footer to calculate your values.

Bert Jansen on 11/23/2009: Dear Richard,How can you make a report of the StatusText? AC 320 Time index 12.43 Thanks.

Richard Rost on 11/25/2009: Bert, I don't understand your question. Can you please clarify? What do you mean by "report of the StatusText?"

Bert Jansen on 11/25/2009: Dear Richard, I mean if I want to print all the data in the statustext you've created like "Anne wilson 45",How can I do that? AC320 Time index 12.43

Richard Rost on 12/13/2009: If you actually want to PRINT the statustext data, then I would recommend creating a status TABLE, binding that control (the big text box) to a field in your table, and then storing it that way. Then you can print it if you want by making a report based on it.

Add Your Questions or Comments