Replies

I agree with Wendell, but I had another idea. I do not like working with the report writer in Access. You may not want to work with VBA. (Many users I deal with don’t know VBA and I don’t have the time to maintain the db for them if something goes wrong.) A way to get around it is to combine the power of Access with the report flexibility of Excel. Not seeing the data or reports they already have, I would write a set of queries and macros that filter the data to what they desire. You could give them a form(s) where they could select the periods to be displayed. Here’s the key, the final step in the process is to write this data to set of tables in Access. Then I would link or import with a macro an Excel workbook to the data. If you need to do any fine tuning with Pivot Table, Dashboard, you can in Excel. You can even write a macro that asks if they want to update the data everytime the workbook is opened.

Just a thought.

Try this:

Go to Tools > Internet Options > Mail Set Up > E-mail Accounts.
Double click on your email account.
Click on “More Settings” in the right hand corner
Click on the “Remote Mail” tab
Adjust your settings here. If Process Marked Items is not selected as the default, start by trying to select it. If it is, then you will probably want to select “Retrive Items that meet…” Then click on Filter > Advanced.

2 Notes:
1. You may have to experiment a little to get it to download only the items you want. I would start with checking “Only Unread” and see if that solves the problem.
2. Always, always, always write down what the settings were before you changed them.

Joe,

I like your suggestion. What is the best way to open an existing or create a new PST in which to drag folders?

Ken

Can you explain what the 9.99E+307 represents in the formula?

Andrius,

If I understand what you are asking, I suggest using the sumif function. To sum all the “b” in column A it would look like this: =SUMIF(A4:A200,”b”,B4:B200)

You can use the same function to find the sum of K: =SUMIF(G4:G200,”b”,K4:K200).

If you want to nest the functions, it would look like this: =(SUMIF(A4:A200,”b”,B4:B200))-(SUMIF(G4:G200,”b”,K4:K200))

Lastly, you can replace the b with a cell reference. If you are going to list the B, C, M, Y in separete cells to indicate which item you are calculating, then change the “b” to refer to the cell (eg N9).

Looking at the formula you have in your spreadsheet, I’m not sure what you want to do with the “colors”. As always you can use F4 or $ to lock the cell reference in the range.

Great column. I’m currently using many of the tools mentioned. I am looking for two other tools to help. I need a tool to find duplicate files on my hard drive (and external drives) and a tool font manager. One that will search my drive and find all the fonts. Then I can make decisions on both files. I am currently running the lovely 🙁 Vista.

Thanks,
Ken