no data

  1. R

    Pivot table show items with no data when group filter applied

    I created a Pivot Table. Table serves two purposes: 1. To list employees (by pay grade) who have completed X, Y, and Z training courses 2. To list employees (by pay grade) who have not completed X, Y, and Z training courses To do this, I merged two Excel worksheets. Worksheet 1 contains a list...
  2. T

    Pivot tables - cannot suppress No Value results

    Hello, I have a large pivot report and with calculated items. The values of the calculated items go in the columns section. If I have one row this works well. But when I add additional rows the No Data cells appear and I cannot suppress them. I cannot access the "Show items with no data on...
  3. C

    Query Effeciency Question

    I am running a group of queries in Access 2010 to sort through records in a table into a work center roster for a given facility. For now, I am using the first query to pull the records just for a given facility. Then, referencing that query, I pull another to get Section A Shift 1 from that...
  4. B

    query to see blank records with no date in them

    I saw a post of yours from a long time ago about this and find myself in the same spot. I will post screenshots and explain as best I can of what I am after. My db is a Check Register db with a scheduler to export the data to the registry table. problem is of course that some events get missed...
  5. C

    Conditionally format based nodata in 2cols but had text in another

    Hi, I'm trying to apply conditional format to any row that has textbin one column and no data in two others. ....................Col C.............Col J.........Col K Row 1...........Text a............1...............1 row 2............Text b.............................. Row...
  6. L

    Data Chart Help

    Hi, Hopefully someone can help with my question. I am creating a chart in Excel. The data from the chart will be based on a selected range (ex. A1:G1). Not every cell will always have data. How do I set it up so that the times where no data is entered, it does not default to $0, which then...

Some videos you may like

This Week's Hot Topics

Top