Search results for query: *

Here is what we are trying to do. We have a Excel document (timesheets.xls) and a Word document (timesheet stats.doc). Now when we in put data into the excel spreadsheet we would like to have the word document updated also. I think I need to run a macro but am not sure. Can this be done and if...

Dave you are the man, Thanks for the help. Ivan

Hi, I am using the ToText function in a query for my report. It takes the currentdate and complies it to be text, however it is removing the 0 in the single diget days of the week. So for example instead of looking like 5/04/2004 it reads 5/4/2004. My report needs the extra 0 in the date...

Okay here is the challenge. I have a form that has a option box, 3 value list , and 2 textboxes. When the user selects all accounts the information from the screen is taken and passed 2 three tables. Each table gets the same info except the quantity which is multiplied by a number. Now what i...

Can you assign a value to a certian table when a user selects a value in a list box. ex. user has 4 tables, each getting the same data. on the form they can select broker, currency, and account. Now what i need to be able to do is when the user selects all accounts each account (except fund)...

thxs Tom, After much revamping of your earlier reply I was able to figure it out, now i just have to go in and make sume changes to a few entrys so that my number will add up. Thxs again. Ivan

thx but now i get an error saying that I cant have an agregate funtion inside a expression. it doesn't like the Sum(sum([net]) inside the equation! do you know any other alternatives.

Well Tom, Thats what I want it to do in the account footer. However in the currency footer I need it to add up the amounts in the account sum that dont have a zero displayed. Thats where the problem inlies becasue if I run that it adds up all the numbers even if it shows me a 0 on the report...

I would like to know if this is possible. I have a sum box in my account footer that has the following code: =iif(sum([size])<>0,0,Sum([net])) now can the following statment work in a sum box in my currency footer: iif(sum([net])<>0,Sum([net])) What I want this box to do is only add together...

Why would this calculation give me a total of two columns instead of a single sum: Unreal: IIf([Current Pos]=0,0,Sum(IIf([Curr]=&quot;EUR&quot; Or [Curr]=&quot;GBP&quot;,[Size]*-1*[Rate]+([Size]*[Revalrate]),IIf([Curr]=&quot;CHF&quot; Or...

thx, But where would the sub total go. Since the report has detail, account, currency, page and report footers. again thanks for the sugestion I will try it.

I have this report called performance, and I have a column in my query with this calculation: Sum Of Size: IIf([Current Pos]<>0,0,Sum(IIf([Curr]=&quot;EUR&quot; Or [Curr]=&quot;GBP&quot; Or [Curr]=&quot;EUR/JPY&quot; Or [Curr]=&quot;EUR/GBP&quot;,[Size]*-1*[Rate],IIf([Curr]=&quot;CHF&quot; Or...

Okay how do I explain this. First I have a report called currency. This report is a select query that takes the data from the table and displays it by currency type, account. At the bottom of each currency type, and account there is a subtotal row that sums up the numbers and gives me a dollar...

Golom, What I dont understand is if I sum the Unreal in the currency report and I get 1,412,038, why is it what I use the same format for the Performance query and I do a sum on the report I get 425,803.

Here is my sql code for both reports Currency: SELECT TBLFund.Curr, TBLFund.VD, TBLFund.Date, TBLFund.Account, TBLFund.Size, TBLFund.Rate, TBLFund.Revalrate, IIf([Curr]=&quot;EUR&quot; Or [Curr]=&quot;GBP&quot; Or [Curr]=&quot;EUR/JPY&quot; Or...

Okay the problem is that I have 2 reports. One called Currency, and another called Performance. Each report has a calculation for a column named Unreal like this: Unreal: IIf([Curr]=&quot;EUR&quot; Or [Curr]=&quot;GBP&quot;,[Size]*-1*[Rate]+([Size]*[Revalrate]),IIf([Curr]=&quot;CHF&quot; Or...

Let me make it simple. Can you paste copied cells in a outlook email window automatically using a macro! ##And yes it is a recorded Macro##

This is what I am trying to do: I have a macro that copys data from the excel sheet then opens a series of emails then stops. Now what I want it to do is copy the data, open the outlook applications, and paste what I just opeied inside each one. Then have it set r1,a1 as the active cell. I...

Heres the delima: I have a report called Performance, and this is what it gives me: Currency Current Pos Net Amount Unreal Rate CHF -2,584,524 0 351,525 1.26 EUR 2,485,200 0 25,125 1.1 GBP -1,744,000 0...

What I need to do is take a number that is generated in a report query and export it to an excel spreadsheet that is already created and has calculations. Currently my report has 8 feilds and of them i need 4 sums that it produces. Can you take a sum produced from a report query and send it to...