Recent content by renante

The user can put whatever beginning period he wants then the query should show the yearly allocation. Since fiscal year starts in april 1, any contracts that starts on the same fiscal year should have a amount equal to the contract start month till the end of the fiscal year. Therefore a...

Sample data ContractNo. Start End Annualcost SSI-001 8/1/09 7/31/15 5,000 SSI-002 12/1/10 11/30/12 15,000 5 year annual projected cost starting from 4/1/08 (expected output) ContractNo. Annualcost FY 2008 FY2009 FY2010 FY2011 SSI-001 5,000...

Hello, I know this would be easy for the experts. I have a query with three 4 fields, contractInfo,AmountperAnnum, begContractDate and Ending Contract Date. Most of the contracts rans from 3 to 5 years. What i need is query that will shows annual cost for 5 years- meaning each column will show...

guys, I was trting to merge records from mytwo table, cash voucher transaction and journal vouher transaction, each table have a account code column. i want to merge them in query where the records from the 2 records where all the records will be group together with account code. I have tried...

Mr. Ramani, I have tried your suggestion and encoded the following: LPARAMETERS nColIndex local myrecno,nTotal myrecno=recno()&&having problems with this line) total grdtxtdr to ntotal thisform.txttotaldr.value=ntotal thisform.txttotaldr.refresh() go myrecno grdtxtdr is the name of my...

Hi Everybody! I have form with a combo box selecting client code from clients table. Because i wanted to limit the size of my record,I only get the code of clients to be included in my sales table. However, when i tried to print the sales form only the code appears! I tried to put the...

I am a beginner of vfp6, I have a grid and a textbox, i wanted my textbox to add all the records i entered in one certain column of the grid. And also what is the command to give a specification on the page of the report that only certain pages will be printed. thank you in advance!