Recent content by keen1598

Seriously? No one knows how to write and interface/subroutine to activate an RDL reports package? I figured this was pretty simple since its just a SQL Report Generator...

So Access was unable to manage the amount of content that I needed to produce in a single report. The reports contain 12 charts/graphs all of which I needed on separate pages (one chart per page). As such I could not create large enough charts in access to fit to each page, as Access limits the...

Not necessarily true about cross tabs. If you read the code, the cross tabs are left joined to data that is wholly comprehensive of all months and years since a starting date. The format of my tables is as such of necessity. I was required to keep a single table of individual transactional...

Hi all, I have 3 cross tab queries that are completely identical with the exception of the field that they pivot. Each field is searching for the same values just in different columns, with the end goal being to get the sum of the values for each pivoted column. I'm wondering rather than having...

Hi All, This is really a two parter: I need to first figure out the best way to save data to a table using the form format I have built, using unbound fields, and also how to load data from a table into those fields after selections have been made and when a control button is clicked. I have a...

Dude, you are seriously my hero.

Is there a way to configure charts to use certain variables and run in the same format as a group report? I don't need a running list of the value so much as visualizations of it in run chart formats. That's where the 12 graphs/charts piece comes in. I run the same charts using the same field...

Well I still have the main query which is all of the data without a WHERE condition, but I wasn't sure for the purposes of creating reports if that would complicate things more or not, so I did by individual groups as well. So essentially when I say report, what I mean is a 12 full page...

This is exactly what I needed. Thank you so much! The crosstab table gave me the foundation I needed to structure my data. Now that I have that I was able to maximize my query. The final result was this: SELECT V_GROUP_UNIT.GROUP, UNIT_DATA.UNIT, UNIT_DATA.INF_YEAR, UNIT_DATA.INF_MONTH...

The data for UNIT_DATA is entered monthly by several individuals, for which I created a form to record everything. NHSN_BM data will be entered by me, because it only needs to be done once annually. The final image is the data sheet I used to builds reports so yes that would be the desired...

Hello all (JHB), Sorry this took me so long. Things, have been a little crazy. Anyway, attached is the redacted version of the tables I would need to use for my calculations in an excel file. Each worksheet is named after the table name from the access db. I also included the datasheet, I used...

I will do this before the end of today. As some of the data is HIPAA privileged information, I will have to redact some of it.

Hi All, I've been trying unsuccessfully for weeks to try and query a usable data set that would later be used for calculated values in a report. I'm building a Hospital Acquired Infections Database for my facility to record data and process reports automatically. Previously, I built the system...