DataBase - Memo Field needs to include field name within field.
Asked By LMW
20-Nov-09 05:11 PM
I need to add a memo field into a report and I need to have the data preceded
by Note:. I used the expression "Note:"&" "&[Note] and now it appears I
have a text field not a memo field. What is the best fix for this?
Report
(1)
DougSteele
(1)
Stiphout
(1)
Memo
(1)
Usedas
(1)
Douglas J. Steele replied to LMW
Can you not just have a label on the report that says Note:?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
Tom van Stiphout replied to LMW
Works fine for me, with a few changes:
="Note:" & " " & [Note]
I am sure it will for you too.
-Tom.
Microsoft Access MVP
Douglas J. Steele replied to Tom van Stiphout
I suspect that the OP had "Note:" & " " & [Note] in the query that is used
as the report's RecordSource, and I believe that will convert the memo to
text.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
Tom van Stiphout replied to Douglas J. Steele
Yes, that is possible. I did mine as an expression in the ControlSource
of the control on the report, and I did get the full memo text, not
just the first 255 chars.
-Tom.
Microsoft Access MVP
LMW replied to Douglas J. Steele
I need the field to expand and I have another field right below it. If I
leave the label on the report the first field could expand and the second
label would not be aligned.
LMW replied to Douglas J. Steele
That is correct. That was my first attempt.
LMW replied to Tom van Stiphout
That worked great. Thank you!
Auto-numbering a list DataBase I have a data base which prints a report based upon starting dates. When I print the report, I want the list to print a number to the left of each name which I need to write some code? Thanks for the help. - - Howard Access Modules DAO Discussions Report (1) RunningSum (1) DougSteele (1) Stiphout (1) Holdthe (1) Textbox (1) Yes, there is a simple and elegant solution. Create a property to True. Done. -Tom. Microsoft Access MVP Add an unbound text box to your report. Set its ControlSource to = 1 and its RunningSum property to Over All (or Over Group, depending on how your report is set up). - - Doug Steele, Microsoft Access MVP http: / / I.Am DougSteele (no e-mails, please!) Tom: Sorry it took so long to reply, but thanks for
blank if all are null? = Val(Nz([STA1], 0))+Val(Nz([STB1], 0))+. . . . . . . . Access Discussions Report (1) DougSteele (1) Question.Thanks (1) U¿ytkownik (1) Stiphout (1) Wiadomo¶ci (1) Properteis (1) Napisa³ (1) Check out the Nz function in the I am trying to accomplish is to keep from having "0" show up on the report that will be printed from this form. I will be getting the sum of and The calculation is being done in a text box on the form and not the report or from a query. Hope this helps. Thank you much = IIf((Val(Nz([STA1], 0 Nz([STA1], 0))+Val(Nz([STB1], 0))+. . . . . . . . ) - - Doug Steele, Microsoft Access MVP http: / / I.Am / DougSteele (no private e-mails, please) I think this is how you are talking about. But the original question. Thanks for the correction. - - Doug Steele, Microsoft Access MVP http: / / I.Am / DougSteele (no private e-mails, please) Ah, sorry, I misunderstood. I noticed you already have the
Page Footer DataBase hi, here's my scenario of my problem i had one report (Report A) and it has a page footer once i viewed it the page footer appears, but when i sub report the Report A on a another report (Report B) the page footer of Report A does show and it supposed to be shown at the page footer of Report B. its there anyway to show the page footer of Report A to Report B
Count and Filter Result DataBase My report has = Count(*) in the group header and I want to filter the results. Report Example: IDnumber Group Header Total of Reports Last Name First Name Idnumber 2 Smith Joe show the records of reports with the total of 4 or more. Access Reports Discussions Report (1) DateDiff (1) Ccumodsactionsother (1) Ccusanctionsother (1) Dateofreport (1) Reviewdate (1) Sonya (1) Unit (1) Try this in the query used as source for the report - -- SELECT [Last Name], [First Name], [Idnumber], Count([Idnumber]) AS [Total of Reports] FROM YourTable WHERE current code for my query. Where would I put the below infromation? SELECT [Minor Disciplinary Report].Last, [Minor Disciplinary Report].First, [Minor Disciplinary Report].IDnumber, [Minor Disciplinary Report].Unit, [Minor Disciplinary Report].Dateofreport, [Minor Disciplinary Report].[Gpsanction 1], [Minor Disciplinary Report].[Asddsanctions 1