Search results

I've created a copy of the file and loaded it with test names. Thanks for your help. I never would have imagined that parsing these names could be so difficult!

As expected, I'm a little lost here. I read through the samples, but couldn't figure out how to adapt any of them to parse through a cell of comma delineated values. It also seems like the Mid$, Left$ and Right$ functions won't work in this case, as they require you to specify a number of...

Thanks. At this point it's looking like it might not be possible. Have a good weekend.

That is what I'm trying to do, but it needs to happen within Access. The source data file for this DB is downloaded daily, so it's not practical to perform any kinds of edits outside of Access.

The problem is that the Access database is being used to generate many other reports on a daily basis, therefore, I'm trying to keep all the reporting in Access as not to complicate things. What I really need is a way to distribute the data contained in one cell into rows of a new table. Is...

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

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

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

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

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

Hit the sigma icon for totals. Create a new column and select "Expression" for total type. Your new column should be: CumQt: DSum("[Qty]","Your_Query_Name","[DemandDate]<=" & [DemandDate] & "")

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

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

I need to create a graph based on the query. I have my running total column as: RunTot: DSum("PSI #","Data","DatePart('m' [* Creation Date]) <=" & [AMonth] & " And DatePart('yyyy',[* Creation Date])<=" & [AYear] & "") But I keep getting #Error in the column. What could I be doing wrong?

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