Search results

Hi , I was trying this out by creating a form in MS Access and using this code in the onlick event of a button . It throws up an error which says " Compile Error - Invalid Outside Procedure" at line Set EmailApp = CreateObject("Outlook.Application") What could be wrong ? Would appreciate...

Thanks Jon ! Yes I'm using Access 2K. I guess I'll try to use the ADO recordset object in my code ,later when I have more time. But for now , this works like a charm! I'm eternally grateful :)

Thanks a lot Jon! It worked ! I'd almost given it up as impossible ! I had to make the following change though: Dim rs As DAO.Recordset instead of Dim rs As Recordset It wouldn't work without that. Kept giving me error 13, "Type Mismatch" Do you know why ? Thanks a million ! Gina.

Hi, I can't see the light anymore ! I have 2 tables : DEAL Table Deal_ID User_ID eg. Deal 1 User 1 USER Table User_ID Name eg User 1 David A deal can have more than 1 users under it . I want to be able to show a concatenated list of all...

Hi, I know of one way to handle your second question. Create a macro like this : SetWarnings - No OpenQuery - YourMakeTableQuery. Good luck :) Gina.

Try this ? select EmplID,Date, TOPP, Sum(NS), sum(MT) from YourTable group by EmpID,Date, TOPP;

U bet it was !! In fact I've searched the forum at every step of that function i wrote !!! And know what ? :( I just had a meeting with the user and the interest calculation he needs is not the one I have !! Two days of work down the drain !!! I could cry !! I wish there were'nt any users...

Thanks Jon ! That clears up a lot of questions !! Thanks Cosmos , u've been a great help !

Hi Cosmos, Thanks ! The source is a query. And to get to the output that i need , I have to use two dates a i did in the function , both a start and a end date. A single date won't do ! It's one interest amount, eg. 1234.56 for 92 days between start date and end date, that needs to be...

Hi Cosmos , Thanks for trying anyway ! I had a closer look at the query and i think a self join is used , not two physical copies as i first thought. whatever it is , it works great ! Thanks, Gina.

Hi , I tried it out and it works fine. If you wish you can post your mdb and I'll help if I can .. Gina.

Hi Cosmos, Yes It's Gina :) Sorry about the mix-up ! I had tried Jon's optimized query with the Select instead of DSUM and was wondering why it wldn't work for me .. Now i realise that there are 2 copies of the same table. That is necessary for this query to work , isn't it ? I didn't know...

YIPPEE!!! Well I still need to improve on it, but it works !!! Could anyone help me with tips for improving the performance. I don't know how it would work for large data... But here it is .. **************************************************** Function Interest_Acc(Facility As Variant...

Hi , Create a field2 in your query which will show values 0, 1, 2 to correspond to field1 L, M, H . and sort on that field. There may be a better way , but this is what I can think of. Hope it works for u :) Gina.

Hi Terri, Even then, your sum amount should not change . It's only the sign that will change. eg. sales -10, - 20, -30 Total : -60 discounts 10, 20, 40 Total : 70 Total Sum : sales + discounts : 10 sales 10, 20, 30 Total : 60 discounts -...

Hi Terri, I assume u'd want to sum the positive and negative numbers and then get the absolute value? eg. yourfield 10 -20 -10 20 -40 ----------- sum : - 40 abs(sum) : 40 u apply the abs() after doing the sum Hope this helps .. Gina.

Hi , Can't figure out this one :( The amount "Interest Accrued/Num of days " will give the daily amount of interest between start date and end date . eg. in the attached excel sheet , For facility 1, 101128.87/92 =1099.23 is my amount for each day between 7/1/2002 and 9/30/2002. What I...

Thanks Jon ! I have to show a zero for the lowest ranking. So now it works fine! Thanks a lot! In case anyone is interested ... IIf([Month]=DMin("Month","ACC 001 - PRINCIPAL","FAC_PID_FACILITY = '" & [FAC_PID_FACILITY] & "'"),0,Val(DSum("Principal","ACC 001 - PRINCIPAL","[Month] <= " &...

DSUM Hi , Thanks for replying. I'm sorry I'm having trouble logging in , so i couldn't reply immediately. I'm attaching my mdb. Hope you can help. Thanks, Gina.

Thanks Sohaila, But i can't base a new query on a crosstab :( NOL