Search results

Yes, I think this is probably the best method to stick with. As ever any help greatly appreciated!

Thanks very much for your advice and reply. Managed to make it work!

Can anyone help me with this one please? My report is generated from a query that prompts for a start time and date and an end time and date into dialogue boxes. I believe this is a parameter query and the criteria is in the WhenScanned column of table ValidScans. The criteria reads...

Hi, I'm a complete novice to Access and wonder if anyone can help me with this one please? I have a column in a query that is the output from a barcode scanner called WhenScanned from a table tblScans. The data in the column is in the format of the date and time for example: 20/01/2006 21:30:00...

Thanks for the reply, sadly the data is in one column only and I don't know any way of separating the date from the time.

Hi, I'm a complete novice to Access and wonder if anyone can help me with this one please? I have a column in a query that is the output from a barcode scanner called WhenScanned from a table tblScans. The data in the column is in the format of the date and time for example: 20/01/2006 21:30:00...