developer155
Programmer
Hello, I am creating a report off the database and I need to pull a couple of fields from a table but I need the output to come back in one field. Example:
Table:
field1 field2 field3
I need the output to be like
field1, field1 some text field 2
so basically return field 1 and 2 as one result plus some text in there. Field 2 is Saturday hours and Field3 is Sunday hours, so the output needs to be like
Saturday: 8-6 Sunday: 9-4
What is the syntax for that
thanks!!!
Table:
field1 field2 field3
I need the output to be like
field1, field1 some text field 2
so basically return field 1 and 2 as one result plus some text in there. Field 2 is Saturday hours and Field3 is Sunday hours, so the output needs to be like
Saturday: 8-6 Sunday: 9-4
What is the syntax for that
thanks!!!