no data

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...

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...

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...

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...

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...

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...