query calcuations

  1. L

    Making row1 as Header for all the queries

    Hi Experts, I have 45 queries data loaded into power query, I need to promote row 1 as header and change column name to “Data” for all the 45queries Instead of doing each query individually, Can I have M language script to do the above at one go? My data sources: It is an excel, with 45 tabs, I...
  2. T

    MTBF Analysis in Access query

    I am trying to determine the amount of days between two dates on a matching serial number. My data has serial numbers that were seen in the past and I am only using the same serial number if it appears twice. I want to know the amount of days in between the date fields we saw these last. The...
  3. B

    Help in parsing a field based on multiple delimiters

    Hi guys -- brand new to Access -- but making good progress. Trying to NOT use VB to accomplish this (for a variety of reasons). I have a field in our database with five distinct strings, separated by a delimited (a slash or "/"). I've been able to successfully write the formula to parse the...
  4. K

    Query calcualtion not calculating for empty fields

    Hi, I'm working in Access 2007 and have a query that bring in fields A, B, C & D, all formatted as currency. I added an expression to subtract B, C & D from A. This only work if ALL THREE (B, C & D) have amounts entered (sometimes all 3 do, more than often only one or none have amounts). The...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top