I have data in the following format:
Item Total
test 1
test 2
test1 5
test1 4
test1 6
test2 7
test3 8
test4 6
test5 3
I want to be able to find the item with the highest total. I know that this would be very easy with a pivot table, but I want to use a function. So I need a formula that...
Thanks Skip.
The pivot table is almost what I want. I made a stacked graph with it. For the actual data, there is many more projects, project managers, and fund types than 3. Is there a way that I can stack the data with one color for each project and one hatch for each fund type; instead of...
I have created a stacked chart in Excel for the following type of data:
Project ProjectManager1 ProjectManager2 Project Manager 3
Project 1 Funds Funds Funds
Project 2 Funds Funds Funds
Project 3 Funds Funds Funds
x-axis has the project managers...
I am using Office 2000. I have set up a word template with bookmarks. I can insert text into these bookmarks. However, I also want to insert an access graph into the word document. Is there an easy way (through vba) to insert this graph into word?
Thanks,
Jeff
We have an Access 97 database on our network. We want to replicate the database so that we can take a laptop out of the office to make updates. We also want to be able to use our pocket PCs to make updates. However, when you create the replica, it adds an autonumber field to the table that...
I have a .tab file that I need to get into Access. I will be getting these on a regular basis, so I wanted to write a command that will automatically do this. I cannot import it directly into Access because this file type is not supported for Import. I know that I can import it into excel...
I am using Access 2000. I wanted to add a logo to my main screen. I added an image box, but the db size increased by about 10 megs. I decided to delete the picture; however, I can not get the db size to return to the previous amount before I added a picture. I tried compacting, but it did...
Before we added the option to search the subissues, this was just a basic select query. The user would just mark a check box for reviewed and type comments into a text box. These would write directly into the tables. I would like to keep a similar structure if possible. The users of this...
I am using Access 2000. The following is my table structure.
tblRegulation:
RegulationID (PK)
Issue
SubIssue1
SubIssue2
SubIssue3
SubIssue4
Comments
Other Fields
tblRegReviewed:
RegulationID (PK)
User (PK)
Reviewed
DateReviewed...
I am using access 97 and I am trying to sync a query with my pocket PC. I cannot do this using Microsoft Activesync. I tried syncing it through Visual CE, but when I try to update the query on my desktop. I get an error that says that "the field cannot be updated". Is there a...
I have set up four crosstab queries. I then made a query that puts all of the crosstab queries together in one query. I use this query as a recordsource for a report. All of the queries run fine. However, when I try to open the report. I get the following error: Microsoft does not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.