Search results

Sir I need help for the below query I need you help in Microsoft Access to fix one query. IN/OUT LOADED/EMPTY TRAILER DATE & TIME IN LOADED 456667 2/10/2019 1:12:00 PM IN EMPTY 53004 2/11/2019 2:00:00 PM IN LOADED 53005 2/10/2019 2:35:00 PM OUT LOADED 53005 2/10/2019 1:00:00 PM IN EMPTY 53006...

I am getting below error. THE MICROSOFT ACCESS DATABASE ENGINE CANNOT FIND THE INPUT TABLE OR QUERY 'QMaxDT'. MAKE SURE IT EXISTS AND THAT ITS NAME IS SPELLED CORRECTLY. Please advise how I can fix.

Let me test both and let you know today and tomorrow.

The goal for this query is to achieve the yard report at any time I run the query. To clarify when I run this query I want to know: what the trailers status loaded/empty/other currently in the yard. I don't need any information on the trailers that are out of the yard. The status must change if...

Thanks for reply and advise, actually I new in Microsoft Access and will fix as you advise. 1. as you wrote is good. 2. as you wrote as good as well but if their is IN mostly their will be OUT as well in order to bring another IN. It is yard database if IN entry happen and in order to bring...

I need you help in Microsoft Access to fix one query. IN/OUT LOADED/EMPTY TRAILER DATE & TIME IN LOADED 456667 2/10/2019 1:12:00 PM IN EMPTY 53004 2/11/2019 2:00:00 PM IN LOADED 53005...