Hi, I am an access newbie who has been left with a database to administer which was designed by a former employee,
I am trying to add a barcode field to a report for a date field (NEWBOX.DATE) in the format dd/mm/yyyy but the field in the table also shows the time after the date,
so when trying to apply the stars at the beginning and end of the field for the barcode reader I am getting *15/10/2010 10:15:53*
I have tried using the trim command in the query but I keep getting the error message
"The function you entered can't be used in this expression"
you may have used a doEvent, Lbound, Ubound, Spc or Tab function in an expression You may have used an aggregate function, such as count in a design grid or in a calculated control field.
Thanks for taking the time to look
Any help would be greatly appreciated
Cheers
I am trying to add a barcode field to a report for a date field (NEWBOX.DATE) in the format dd/mm/yyyy but the field in the table also shows the time after the date,
so when trying to apply the stars at the beginning and end of the field for the barcode reader I am getting *15/10/2010 10:15:53*
I have tried using the trim command in the query but I keep getting the error message
"The function you entered can't be used in this expression"
you may have used a doEvent, Lbound, Ubound, Spc or Tab function in an expression You may have used an aggregate function, such as count in a design grid or in a calculated control field.
Thanks for taking the time to look
Any help would be greatly appreciated
Cheers