METRO Blue Line-The Blue Line offers fast, frequent service from downtown to Mall of America. Trains leave roughly every 10 minutes during most hours on weekdays, every 15-30 minutes on evenings and weekends. Travel time from end to end is 39 minutes. More about riding the train.
Add a query to an Excel worksheet (Power Query). Important This article applies to Power Query, a data analysis feature available for Excel that lets you discover, combine and refine data. You may need to enable Power Query in Excel.
In the query design grid, add the following expression to a blank field text box: PurchaseYear: Year([PurchaseDate]) and enter the following in the column's Criteria text box: Year(Now()) The query design should look like the following: Microsoft Access Query design to query for records in the current Year.