Recent content by akumar118

  1. A

    Populate table using combo box from from

    I have two tables A and B. I want to populate the table A through a data entry form from table B which has Employee name and EMP NO. ActuallyI could populate the table with EMPNO which is numeric data. However, I am unable to populate the employee name. Kindly Advise.
  2. A

    Populate table using combo box from from

    I am developing a computer hardware inventory cum repair details. I want to enter data using combobox I as I already have values. the value is a "Text" i.e. it is a identity given go each peripheral which is Alphanumeric. I was successfull in getting combobox for Numeric value but...
  3. A

    Report calculation..

    I shall try
  4. A

    Report calculation..

    Thanks that ws very fast, I am developing a DAK MANAGEMENT SYSTEM, which would give you the position of all the letters received in the office. i.e. When was received, to whom was the letter given and the present status of the letter. I have managed to develop a Data Entry screen on one single...
  5. A

    Report calculation..

    Friends, I am developing a DAK management System. I designed a table with fields viz. srno,date,disposed(Boolean) I created a query which will ask for startdate and end date. What i I am looking for : a report showing the following Outstanding letters (previous fortnight) Receipt...
  6. A

    Running sum... in Report...

    I downloaded the file and went through the report file. Well,What I need is : As mentioned earlier in query i calculated a cumulative field of total in a new filed CUMTOT. In the report I placed the CUMTOT field and set the value asl RUNNING SUM OVER ALL. Now I want to sum this CUMTOT in the...
  7. A

    Running sum... in Report...

    Friends, I need to sum a running sum in report. I used SELECT T1.SRNO, T1.TOTAL, (SELECT SUM(PFINTQ.TOTAL) AS CUMTOT FROM PFINTQ WHERE PFINTQ.SRNO <=T1.SRNO ) AS CUMTOT, T1.[PF NO], T1.DATE, T1.UNIT_NAME, T1.DESGN, T1.OBAL, T1.SUBSCRIPTION, T1.VDPF, T1.REFUND, T1.WITHDRAWAL, T1.LEDG_NO...
  8. A

    1) REPORT_ID UDATES 2) HQ\\SPL\2-16\07-08\Dated...

    1) REPORT_ID UDATES 2) HQ\\SPL\2-16\07-08\Dated: 01/04/2007 01/04/2007 Srl No is field Headin Srl No2 are the data Data under the field Report_id is combination many fields including Date What I want is to extract the DATE DATA AND CONVERT IT INTO DATE SO...
  9. A

    Urgent Please

    Urgent Please
  10. A

    1) REPORT_ID UDATES 2) HQ\\SPL\2-16\07-08\Dated...

    1) REPORT_ID UDATES 2) HQ\\SPL\2-16\07-08\Dated: 01/04/2007 01/04/2007 Srl No is field Headin Srl No2 are the data Data under the field Report_id is combination many fields including Date What I want is to extract the DATE DATA AND CONVERT IT INTO DATE SO...
  11. A

    Online Filing system..

    Acess... Yes Sir...
  12. A

    Online Filing system..

    I have 5 computers in my office. What I want is after networking these computers, I want that the Office note and other work done by one employee should go to another with some pasword and it should also have a log details.
  13. A

    Easy Question - Calculate Days in Month

    Excellent.. A Very Very Happy prosperous,Peaceful and a wonderful New Year. I am a newbie to Access and has just began to do develop some database prog. on PMIS (Perso.Mgt. Inf.System for my office) I wanted date of Retment to be last day of a given month. I was confused how to get it.However...
Back
Top Bottom