Really two questions dealing with Reports in Base.
I am putting together a small database for my wife. It contains name & address information, various items relating to the organization and a photo of each member. I have managed to place photos into forms by using an external photo link (Photo path). I also managed to concatenate the First Name and Last Name fields in a query that I had planned to use to generate the final report, which will be the organization’s roster.
I cannot see how to enter the path to the photos in the reports or to get the report to display the concatenated names. In the query I used the following to get the concatenation: “First Name” || ’ ’ || “Last Name”
I suppose one work-around for the concatenated name is to just make a Full Name field and sort on Last Name and First Name.
I’ve tried using a Text Box in the report but cannot make any entries into it. Same with a graphics box. I had thought I could try entering the concatenation expression into such a text box.
I’m sure the answer is probably simple, but at the moment I am completely flummoxed on this.
Any suggestions would be gratefully appreciated. Thank you very much.