MTS to MP4 Conversion : Tech Support: creating additional lines of data in a query

Friday, September 23, 2016

Tech Support: creating additional lines of data in a query

creating additional lines of data in a query

I have a database that tracks out of service vehicles.
As seen below, there is an initial out of service date and an end date.
I am tasked with creating a query that shows how many vehicles are out of service each day.
As seen in the example below, a simple count by “Report_Date” will give me the count of vehicles out of service each day, but will not count the vehicles that are out of service from the previous day.
For vehicles that are returned to service the same day they break down, no problems.
For vehicles that are out of service for multiple days creates a problem for me.
Table Example:
Vehicle
Start_Date          End_Date            Days_Out_of_Service
Report_Date      Comments
V12                        10/1/2013
10/1/2013                            1
10/1/2013
V20                        10/1/2013
10/3/2013                            3
10/1/2013
V14                        10/2/2013
10/2/2013                            1
10/2/2013
V06                        10/2/2013
10/3/2013                            2
10/2/2013

Question:
How can I create a query that will insert additional lines so the vehicle will have a line for each day it is out of service as shown below?
(Note: the repeated line items will be used for other data querying also, so it will be helpful to have the additional line items.)

Vehicle
Start_Date          End_Date            Days_Out_of_Service
Report_Date      Comments
V12                        10/1/2013
10/1/2013                            1
10/1/2013
V20
10/1/2013            10/3/2013
3                              10/1/2013
V20
10/1/2013            10/3/2013
3                              10/2/2013
V20
10/1/2013            10/3/2013
3                              10/3/2013
V14                        10/2/2013
10/2/2013                            1
10/2/2013
V06
10/2/2013            10/3/2013
2                              10/2/2013
V06
10/2/2013            10/3/2013
2                              10/3/2013

Thank you!

Anwsers to the Problem creating additional lines of data in a query

Download SmartPCFixer to Fix It (Free)

You'll need a little auxiliary table to do this: I call mine Num, with one Long Integer field named N as the primary key (and only field).
Fill this table manually (or copy and paste from an Excel spreadsheet using Fill Series) with numbers from 0 through
10000 or so.

You can then use a query like

SELECT [Vehicle], [Start_Date], [End_Date], DateDiff("d", [Start_Date], [End_Date] AS Days_Out_Of_Service, DateAdd("N", [Start_Date]) AS Report_Date
FROM yourtablename, Num
WHERE Num.N <= DatedDiff("d", [Start_Date], [End_Date]);

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve creating additional lines of data in a query in Windows.

Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
Close the Command Prompt Window because we are done.

Try and see if you still get the same error creating additional lines of data in a query in your Windows.

Note: You may be prompted to enter your administrator's password when you try to execute certain system tasks!

Recommended Method to Fix the Problem: creating additional lines of data in a query:

How to Fix creating additional lines of data in a query with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed

MTS to MP4 Conversion