Search results

Hello, I have created a query that uses the MaxofDate function to retrieve logbook entries created on the last day of work in our section. This query creates a report that can be accessed from a "quick link" button on the main menu of the database. This function works great except that once a...

I have a text box on a form where a user can enter a customer control number. These numbers are formatted as follows RED12-HK001 or RED12-1Z001 where the characters HK or 1Z represent the account codes and other characters represent equipment (RED), the year (12) and the sequence number...

Hi. My name is Bob and I work as a simulator technician here in Canada. I have been creating Access databases for some time but up until now they have been relatively simple affairs, using only the built in functions available in Access. I have recently been tasked to create a much larger...