Search results

I found this in a book which builds on your code: PivotTables and PivotCharts In previous versions, Access forms could be confi gured to show data in PivotTable and/or PivotChart view, which was effective for displaying multi-dimensional data or for rendering aggregated data in a visual...

OK, so I took a look- pretty intense. Thank you. What I'm trying to do is to create the pie from the data table, and have it with the labels, and percentages on a report. I'll use this as a stepping stone. If you have the time, a report demo would be helpful. A pivot pie can be created almost...

Thank you very much. Ill take a look and let you know if I have questions.

Awesome thanks.

Obstacle..have restictions to download and home is older access...Is it handled through vba?

Anyone have resources for charts, bars, on reports and know how to add numbers and percentages on charts like excel?

Got it thanks. Seems like a report was easier.

Have a cross tab with a total of each row and want to add percentage of total to each row similar to a pivot. It seems like it shouldnt be that difficult. Any guidance will save me time. Thanks.

Thanks. Never had that one before. Just another reason I love access is the support community right here.

I need it in a query. Only begins with *

Does anyone know how to query a field which begins with a wild card character "*". Cant seem to get it using Like.

Figured it out. Thanks.

Its gonna be something like: IIF ([Valid] Is Not Null and IIF ([Expired] Is Not Null, "Ok" , "")) All have to be null for one result.

I forget how to do this query. If i have multiple fields which are not null then i want to result in specific text. Field 2 null Field 3 null Field 4 null Result A Field 2 null Field 3 null Field 4 not null ""

how do I get id field separated into rowa

mook the field with multiple entries are suppose to split into rows

To answer your question, this is not the actual dataset though understand your concerns and probably just how I entered it.. I would eventually just turn off warnings. I need to know how to also append additional fields.

Please help me. I've spent so much time on this troubleshooting and been coding for a couple of years or so. I've coded HTML VBA and straight SQL VBA but got caught up on this one big time. Research is critical in this line of work is important I suppose. I know this is quite simple but tried...

Access integration with Sharepoint 2013. Just looking for eveyones opinion on using access as a tool for charts, graphs, and metrics. I feel as though it has many limitations but wanted to get some feedback or resources to articulate and tell me otherwise. Thanks

Solution to seperate column with 3-4 words seperated by comma into 4 columns: Sample Field Record set [CGY, Norad, Tech, Jones] Left([Entity / Department / Function / Unit],InStr([Entity / Department / Function / Unit],", ")-1) AS Entity, Left([String],InStr([String],", ")-1) AS Department...