I recently viewed a video showing the function wizard being used to create a formula for city, state, zip for a single field in a report. Is this wizard available when creating forms?
1 Like
Hello,
Do not see why it would be. Why would you want a form to do that unless it is just for displaying data. In that case, use a query to display that format by concatenating the fields wanted.
.
Also, if you are going to refer to a video or another question, please provide a link so others see just what it is your are looking at.
Edit:
.
Example SQL if using HSQLDB embedded database:
Select ID, "city" || ', ' || "state" || ' ' || "zip" As "Combined Field" From "MyTable"
1 Like
This was the video I mention earlier. About 3:15 into the video.
Thank you for the link. Figured this is what you referred to. The same is accomplished using SQL & concatenate. Query can be sent to Report Builder and bypass this process.
1 Like