---
title: How to Batch Assign the Query Rate Column in the Manage CP Applications/Query Columns Page
description: The functionality exists to quickly assign the query rate column for Foliars, Fungicides, and Insecticides.
---
[Skip to content](https://processes.premiercrop.com/knowledge/how-to-batch-assign-the-query-rate-column-in-the-manage-crop-protection-actuals-page#main-content)
[Customer portal](https://processes.premiercrop.com/tickets-view?hsLang=en)
![PCS-Black-icon-1.png\]](https://processes.premiercrop.com/hs-fs/hubfs/PCS-Black-icon-1.png?width=35&height=40&name=PCS-Black-icon-1.png)
- [Tickets](https://processes.premiercrop.com/tickets-view)
- [Sign out](https://processes.premiercrop.com/_hcms/mem/logout)
Open main navigation
Close main navigation
- [Tickets](https://processes.premiercrop.com/tickets-view)
- [Sign out](https://processes.premiercrop.com/_hcms/mem/logout)
- [Customer portal](https://processes.premiercrop.com/tickets-view)
- [Go to premiercrop.com](https://services.premiercrop.com/)
[Go to premiercrop.com](https://services.premiercrop.com/)
What do you need help with today?
- There are no suggestions because the search field is empty.
1. [Premier Knowledge Base](https://processes.premiercrop.com/knowledge?hsLang=en)
2. [Premier Crop Systems Software Training](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en)
3. [Crop Protection](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#crop-protection)
# How to Batch Assign the Query Rate Column in the Manage CP Applications/Query Columns Page
## The functionality exists to quickly assign the query rate column for Foliars, Fungicides, and Insecticides.
You **MUST** set a query rate column for **Foliars, Fungicides,** and **Insecticides** in order for that data (including costs) to pull into Reports, Dashboards, and Queries.
1. After [assigning](https://processes.premiercrop.com/knowledge/how-to-assign-a-crop-protection-application-to-actual?hsLang=en) a Crop Protection Application to the desired field(s), if a Foliar, Fungicide, or Insecticide was used, you will need to assign a Query Rate Column for it.
2. Click on the **Crop Protection** tab, then select "Manage CP Applications/Query Columns".
3. After navigating to the desired Grower (you can drill down further, if need be) and year, click the "Load" button.
4. You will see how many Query Rate Columns need to be set.
5. To rapidly assign the same Query Rate Column, select the **Product Type**, **Product Name,** and the **Query Rate Column** from the dropdowns.
1. **Timing:** You do not have to select anything from this dropdown, unless you need to. *Example: You have two applications for the same product at different times, then you could select **Miravis Neo**, **V7** and assign it the **Fungicide 2** Query Rate Column, then select **Miravis Neo**, **R3** and assign it to the **Fungicide 1** Query Rate Column.*
6. Select the field(s) that you want to assign, then click the "Assign" button. *Note: It will only assign the Query Rate Column to records it finds, so if a field doesn't have that product in it's application, then nothing will happen.* 
7. Keep working until all Query Rate Columns have been set.
If you have any questions, please contact your advisor support representative.
The [Uniform Data Entry Guide](https://processes.premiercrop.com/knowledge/how-do-i-enter-data?hsLang=en) can assist you with entering in the Query Rate Columns.
- [Getting Started with Premier Crop](https://processes.premiercrop.com/knowledge/getting-started-with-premier-crop?hsLang=en#main-content)
- [Advisor Excel-erator](https://processes.premiercrop.com/knowledge/getting-started-with-premier-crop?hsLang=en#advisor-excel-erator)
- [Premier Crop Systems Software Training](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#main-content)
- [Field Management](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#field-management)
- [Nutrients](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#nutrients)
- [Mgmt Zones](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#mgmt-zones)
- [Seed](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#seed)
- [Crop Protection](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#crop-protection)
- [Operations](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#operations)
- [Premier Intelligence](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#premier-intelligence)
- [Data Exchange](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#data-exchange)
- [Reports](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#reports)
- [Analytics](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#analytics)
- [Dashboards](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#dashboards)
- [Webinars](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#webinars)
- [System Information](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#system-information)
- [Tips and Tricks](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#tips-and-tricks)
- [Unpublished Videos](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#unpublished-videos)
- [Release Note](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#release-note)
- [Analyst Studio](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#main-content)
- [Getting Started](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#getting-started)
- [Visualizations](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#visualizations)
- [Filters](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#filters)
- [Calculated Fields](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#calculated-fields)
- [Exporting](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#exporting)
- [Hardware & Software](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#main-content)
- [Ag Leader](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#ag-leader)
- [Case IH](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#case-ih)
- [John Deere](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#john-deere)
- [Kinze](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#kinze)
- [Precision Planting](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#precision-planting)
- [Raven](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#raven)
- [SMS](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#sms)
- [Trimble](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#trimble)
- [Sales](https://processes.premiercrop.com/knowledge/sales?hsLang=en#main-content)
- [Sales Resources](https://processes.premiercrop.com/knowledge/sales?hsLang=en#sales-resources)
- [Partner](https://processes.premiercrop.com/knowledge/sales?hsLang=en#partner)
[](https://4362973.hs-sites.com/knowledge?hsLang=en)
Premier Processes
Copyright © 2026, Powered by Premier Crop Systems