Need Help to create "YARD IN QUERY"

[dhawan_aj]

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 the trailer leaves the yard: in other words it will not appear on the query anymore.


These are four columns IN/OUT, LOADED/EMPTY, TRAILER#, DATE & TIME


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 2/11/2019 10:35:00 AM
IN LOADED 53665 2/9/2019 4:00:00 PM
OUT LOADED 54334 2/10/2019 3:10:00 PM


Please advise how I can get those results in the query. "HELP ME"

 

[dhawan_aj]

One more thing to ask if I want to add row number in the front of the row and all the column text setting in the center of every column, Is that possible?

 

[smozgur]

If you need row numbers sequentially (1, 2, 3, 4 ....), then I don't think it will work as you need for this "JOIN-itself" query in Access.

The other way is using a report instead using raw query result. You can add a new text field that ControlSource is "=1", and with Running Sum.

Can you please explain what "all the column text setting in the center of every column"?

 

[dhawan_aj]

Yes I want all the column text align in center.

 

[smozgur]

Then you should consider creating a report with this query as the source, and set the text box control alignment to be center aligned.

Also, as I tried to explain in my previous reply, for the row numbers, create a new text box control on the report, set it's ControlSource property as "=1", and also select RunningSum to be Over All in the object properties window of this new text box control.