Search results for query: *

thx carp, you were right about the duplicates and the group by so i just adjusted the function to return the TOP 1 record and its working now CREATE OR REPLACE FUNCTION GET_CURRENT_EARN(inMbr in person.person_id%type) RETURN NUMBER IS v_Event number(5); begin select * into v_Event...

Well... i was successful in creating a function that would return the most current Earning record when passing in a PERSON_ID CREATE OR REPLACE FUNCTION GET_CURRENT_EARN(inMbr in person.person_id%type) RETURN NUMBER IS v_Event number(5); begin select a.EARNINGS into v_Event from...

So I have 2 tables: PERSON -> is a table of basic info regarding members in the company (unique key here is PERSON_ID) sample records: PERSON_ID DEPT 123 abc 111 abc 100 bdc 200 cda 140 abc EARN_HIST -> is a table of historical earnings...

thanks SMAH, it helped me out a lot... saved me tonnes of time thanks everyone who replied so quickly

Hi, I have a folder from work that contains about 4000 PDF files, each named something different However, in each file name, somebody decided to put the number '4' before the ".pdf" So, my filenames are "myfile4.pdf", "yourfile4.pdf", "testfile4,pdf", etc.... Is there a way that I can write a...

OMG... thank you guys... i appreciate all your help ... this will TOTALLY save me a bunch of time for the future really thank you.. much appreciated here's my final script @echo off cd "H:\work\Projects\SAM\test" FOR /F "tokens=1,2" %%i in (users.txt) do copy BES_Front.mdb "BES_Front_%%i...

Hey guys... the script sample you gave worked... but only have 1 little problem so i didn't make any changes to the script: @echo off cd "c:\temp" FOR /F %%i in (users.txt) do copy 1.doc 1_%%i.doc echo done pause cls However, in my users.txt each line contains the first and last name of a...

oh geniuses... i knew the art of DOS haven't been lost to the world.. i'll have time to try it tomorrow at work.. so thanks for the quick responses... i'll post my result afterwards cheerios

Hello all, I've been doing a certain task at work manually for a long time and it has reach the point where I would like to create a batch script so that I could run it in DOS (yes, i know it doesn't exist anymore.. but i still like to call it by that name). My work runs a WinXP Pro...

I'm sorry.. but i'll need more guidance for FollowHyperLink... because Lotus links isn't just a string like URLs, is it?

Hello, I've searched online left and right... and I can't seem to find the answer that i'm looking for... Its possible that this cannot be done, but I need to ask the people in this community If I'm designing an Access form, can I create a button that opens a Lotus Notes document link? The...

Hi, sorry, I did mean to say table formatting... I'm not having any problems with the queries, its the table formatting that I would like to have transferred as well when its a table

Oh.. and I forgot to add this important point... I have multiple tables/queries that I need to transfer to the same excel file... this is why I'm using TransferSpreadsheet but I need to keep the formatting at the same time is this even possible in Access?

I have briefed both DoCmd.TransferSpreadsheet and DoCmd.OutputTo. Both have their strengths and their purpose. DoCmd.OutputTo Method is great if one is transferring a single Table or Query to a spreadsheet. However, I need to export several Tables to different worksheets in the same Excel file...

thanks for the formula ck1999 =IF(DAY(F7)=16,(IF(DAY(F6)=1,((MONTH(F7)-MONTH(F6))*2)+1,(MONTH(F7)-MONTH(F6))*2)),((MONTH(F7)-MONTH(F6))*2-1)) this code does work to calculate current year... Now as i mention initially, not only do I need a column to keep track to current year total, but I also...

what's if it's a mid-month change... For example: 2007/4/1 $50 2007/6/16 $30 2007/8/16 $40 2007/10/1 $50 How do I determine that it's $50 for 5 periods, $30 for 4 period, $40 for 3 periods, etc?

because the SUM of the PAYMENT column doesn't take into account how many payments are paid for each value.... In the example I gave, the SUM(payment) equals only $390, but the Total I'm looking for is $1260 (as indicated in bold) As a note to whoever else is going to read this... the most...

Hi, I have a problem which may be a bit too complex for me to handle in Excel. I'm usually pretty good, so for me to ask for help means this should be a challenging question Let's begin.... Current Situation: /*SAMPLE SPREADSHEET*/ DATE: PAYMENT: MonthElapsed 2007/1/1...

thank you LonnieJohnson ... that worked... thanks all for helping

Good question.. that is one of my problems... but I figured that if I set the form's recordsource = "SELECT * FROM tlbTmp".. shouldn't it display the entire table content no matter what.... am I wrong? cheers