Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Reporting on information
- Thread starter LTPJ
- Start date
You can combine a number of fields in the Query grid, by typing a variable name, a colon 
) and the field names you want to combine. A couple of examples are -<br><br>Variable1: [FieldName1]&[Fieldname2]<br><br>Variable2: [Fieldname2]*[Fieldname3]<br><br>Variable3: [Fieldname3] & Variable2<br><br><br>etc<br><br>You can report between dates and times by setting the criteria for the relevant fields using the Between operator<br>An example:<br><br>Between [StartingDate] and [EndingDate]<br>For a parameter query use something like:<br><br>Between [Enter the Starting Date] and [Enter the end Date].<br><br><br><br>Lightning
) and the field names you want to combine. A couple of examples are -<br><br>Variable1: [FieldName1]&[Fieldname2]<br><br>Variable2: [Fieldname2]*[Fieldname3]<br><br>Variable3: [Fieldname3] & Variable2<br><br><br>etc<br><br>You can report between dates and times by setting the criteria for the relevant fields using the Between operator<br>An example:<br><br>Between [StartingDate] and [EndingDate]<br>For a parameter query use something like:<br><br>Between [Enter the Starting Date] and [Enter the end Date].<br><br><br><br>Lightning- Status
Similar threads
- Locked
- Question
- Locked
- Question