Search results
-
M
Split Query Field into Sub Queries/Tables
I have an excel file that contains the fields: [Event ID], [Event Name], [Required Attendees], [Actual Attendees] All of the names of the required and actual attendees are listed in one cell in the event record. The names are listed in this format: Doe, John H; Dow, Jane M; I need to figure... -
M
Pie Chart Design in Report
I am trying to put a pie chart in a "team report." The chart shows open issues for each team. I would like to have the chart colored as follows: critical (red), high (orange), medium (green), low (blue). I have no problem setting this up initially, however, as soon as I open the report for a... -
M
Report with Parameter Query/Form
I need to set up a report that shows four different charts, each based on a different parameter query. Is it possible to attach my four parameter queries to one parameter form? I want the user to be able to open the parameter form, select a "Team" and then view the four charts for this team on... -
M
Create Graph/Report/PivotChart from Running Sum Queries
Has anyone had trouble creating a graph of the running sum field? I am new to Access and trying to create a comparison graph using two queries: Query 1: [Yr], [Mth], [Count_New_Issues], [Total_New_Issues] Query 2: [Yr], [Mth], [Count_Closed_Issues], [Total_Closed_Issues] Where... -
M
Graph totals from two queries with different data
I am new to Access and trying to create a comparison graph using two queries: Query 1: [Yr], [Mth], [Count_New_Issues], [Total_New_Issues] Query 2: [Yr], [Mth], [Count_Closed_Issues], [Total_Closed_Issues] Where [Total_New_Issues] and [Total_Closed_Issues] are running sums. I am trying to... -
M
Graph based on running totals
I need to create a graph that shows the cumulative number of Open vs. Closed issues on a month-to-month basis in an issue tracking database. The data table has the fields [* Creation Date] [Closed Date] [* Status] [PSI #] I have created 2 queries (one for open issues and one for closed issues)... -
M
Running Sum in Query for Count Field
I would like to create a running sum in a column of my query. The query is currently set up with fields: Yr Mth PSI # * Status The PSI # is a Count field, which counts the number of records within each year and month by their creation date. The * Status has a criteria of "New" so that only...