I have data that is being processed through multiple queries that needs to be in a specific final product. All has been going well until I stumbled upon a problem. My goal is to take these two queries and essentially join them together. The ID and Date column are the same and should be together, so I made a union query to handle that, but the meter, and odometer columns need to be separate. When there is a meter reading, the odometer column should have a zero and vice versa. Instead, the Asset ID column duplicates itself and we get hundreds of records.
Here are the three queries:
Here is the place I start trying to get the query to where it needs to be, but have not had much success:
I've tried many things to get this to show the data as described, but have had no luck.