Combining (joining) Fields together in a Report.

[atiq]

I am tyring to join two join fields together in a Report in the follwoing format:

Date: [DateOfDetention]
Time: [TimeOfDetention]

i have attempted this using the following code, but doesnt work:

="Date:" & " " & [DateOfDetention] & "
" & "Time:" & " " & [TimeOfDetention]

Can someone help me solve this problem. Thanks

[pks00]

I am tyring to join two join fields together in a Report in the follwoing format:

Date: [DateOfDetention]
Time: [TimeOfDetention]

i have attempted this using the following code, but doesnt work:

="Date:" & " " & [DateOfDetention] & "
" & "Time:" & " " & [TimeOfDetention]

Can someone help me solve this problem. Thanks

Easier solution might be just to create two labels on the left hand side. These labels will be captioned with Date and Time. This way u dont need to worry about prefixing DateOfDetention and TimeOfDetention

alternative is to modify the query. If this report is based on a query, then u can tweak the query to prefix it with Date and Time. Note though, u will have to reformat date as well
eg

select "Date: " & Format(DateOfDetention,"Short Date") AS DOD, ...

then the report picks up from DOD instead of DateOfDetention

[atiq]

Nice one! never though of that simple alternative method. like they say, two heads r beta den 1. Thanks for your help.

[pks00]

No probs :)