Search results

Hey Access 97 Users! I used the Wizard to create a Pie-Chart, but I would like to add a "Total Number of Responses" box, since I have the pie chart showing %. This sounds terribly basic, but I can't get a box to go with the Totals label, that will actually show the total. The code I get (at...

You both are way above me, so feel free to throw this away if it is off base, but... if <AutoNumber> is saving any records that you don't want in your table, and this is messing up the count sync, delete the blank records. Then make a copy of the entire table, naming it almost the same as the...

WOW! Thanks to you all for the excellent & quick responses! I'll put them to good use. ...grb I've just returned from my workstation (yes, I have to go to the other end of the bldg, to access this web site), and I want to let you know: I could not...

Access 97: In an effort to tweak a database for optimal acceptance by users, I would like to know if this is possible: As you know... from the /Tools/Startup... window you can select which object to display upon startup. For me, it is an input form. My form is used best and looks best if...

On a Pie-chart Form, I have placed a text box labeled - Total Responses:________. I want to show the Total Responses on the form and thought I could use a text box to do it. Is this wrong? I have a query that shows the Total Responses, but the Text Box doesn't show this total, so I must...

Been racking my brain on this some more. For anyone that want's a shot at it too, this may help: The row source for my chart currently looks like this: SELECT [Day], Count(*) AS [Count] FROM [Data Table] GROUP BY [Day]; The Data Table has the field (Day) that shows what day was selected...

Thanks for your reply. I have tried sorting a query in ascending order (no problem), but when create the chart, it still puts it in the order it wants. Either I missed a key point in the conversion, or I need a different solution. What do you think? P.S. I tried zipping a very small sample...

I found a way around this issue. However, if you have a solution I would love to hear it... for future reference. Thanks! ...grb

Access 97: I have a Column Chart Form showing the Days of the Week as the Labels to each column. They appear in Alphabetical order by default. How do I change their order to Chronological, or any order I want? Thank You! ...grb

97 Pro's, I have a column chart that has enough space to show all the column labels, but it skips every other one instead. Is it possible to force it to show all the Labels. (Data has been entered in all areas). Thank You! grb

Awsome Swap! Outstanding! Thank you Jon K !!! The Code worked perfectly! ...grb My Thanks to Ian too... it looks like almost the same code, but I couldn't make the logic leap until it was really spelled out. ...grb

Still trying to swap Columns & Rows Thank you for the reply Fornation (Ian). I do not understand your solution. (Sorry) Let me try a rephrase: I have 8 fields. Each is a persons title. My current query shows each field (title) and the sum of the number of times that title was...

Hey 97 Pro's! I have an existing database with column and Pie chart output forms that I am attempting to modify, in order to display data as needed by others. The data for a pie chart is: "Excellent", "Good", "Poor", "No Response", and "N/A". The Pie chart currently shows the...

If you would like an easy problem, please answer this one for me... I have a query with 8 (or more) field names, just call them A, B, C, D, E, F, G, H, and a single row showing the totals from a table with the same field names. I want a query with only 2 fields: one showing the field names...

Maybe it's a querry problem, not a form? Thank you doss! I really appreciate the help. As I studied your answer, I realized how difficult it is to get the whole picture, or to accurately define the problem sometimes. I could not apply your solution to my problem, but you helped me define...

Access 97 pro’s, I would love some guidance on a very basic problem. I have an input form that mimics its paper counterpart for ease of data entry, but I am having trouble getting the desired output. Here is an example: I have a row of ck-boxes with the following labels: RN, LPN...