Injury Crashes at Intersection

Practice Query: Injury Crashes at Intersection

• Navigate to the Advanced tab in the search area.

  • Click Ad Hoc Queries

    • Click the New button.

Open

• Enter the Query Name: ‘Injury Crashes at Intersection,’ Database, ‘Data,’ and Data Source, ‘All,’ as shown below.

Open

Enter criterion 1. Select Crash in the Form section. Select Junction in the Group section. Select JunctionJunctionLocation in the Field section. Select Exact Match in the Action section and click the New button (shown below):

Open

• Select Intersection in the Search Value Editor window and click OK.

Open

Intersection will appear in the Value(s) section. Click the Add button to add this criterion to the query. It will now appear in the Query Criteria section down below.

Open

Enter criterion 2 from the Table above. Select Crash in the Form section. Select Form Information in the Group section. Select Status in the Field section. Select Exact Match in the Action section and click the New button (shown below):

Open

• Select Transmitted in the Search Value Editor window and click OK.

Open

• Transmitted will appear in the Value(s) section. Click the Add button to add it to the Query Criteria.

Open

Enter criterion 3 from the orange table above. Select Crash in the Form section. Select Summary in the Group section. Select SummaryTotalInjured in the Field section. Select Greater Than in the Action section and click the New button (shown below):

Open

• Enter the number 0 in the Search Value Editor window and click OK

Open

• 0 will appear in the Value(s) section. Click the Add button to add it to the Query Criteria.

Open

Enter criterion 4. Select Crash in the Form section. Select Summary in the Group section. Select SummaryDateOccurred in the Field section. Select Range in the Action section and click the New button (shown below):

Open

Check the Prompt user for search value box* and enter something like ‘Enter date range:’ for the Prompt Text. *Note: Checking this box will ensure TraCS asks the user for the Date Range every time this query is run. In the next steps, we add a default date range which will appear every time this box opens, but this can be changed each time the query is run.

Open

To retrieve the correct amount of data four our training purposes, we will choose a default date range. Click on the down arrow on the selection box next to the “From:” box. This will open the calendar. Click on the Month Year (shown below) to switch to the month selector.

Open

• Click the year toward the top of the window to switch to the year selector.

Open

• Click Jan and 1 to set 1/1/2018 as the From: date. Repeat this process to set 12/31/2018 as the To: date.

Open

• [User Entered Value] will appear in the Value(s) section. Click the Add button to add it to the Query Criteria.

Open

• All four criteria should now be filled-out in the Query Criteria section. Click Finish to save your query.

Open

• After clicking Finish you will be taken back to TraCS Forms Manager. Select Injury Crashes at Intersection and click View Results to proceed to the Ad Hoc Report Builder screen.

Open

Under the Choose Field(s) column on the left, expand the Crash item. Expand Location and check the following boxes:

Open

Change column header names:

1. Click the Edit Captions button below the Footer Text field (shown above).

2. Click the down arrow for Choose Column and select CRASH_SUMMARYSUMMARYDATEOCCURRED.

3. In the Caption field, enter ‘Date Occurred.’

4. Click Apply.

5. Click the OK button.

6. Repeat steps 2 – 5 until all column header names are changed.

 

Open

 

• Click the Export button and save the file to the desktop in the desired File Format (XLSX, PDF, etc.).

Open