Search results

  1. S

    Data field in lable

    I am creating a report in Access 2013 where I am trying to place an statement by placing lable (See attached snap please) which contain a specific data from table field i.e. ---------------------- Dear Sir, We provide you with the particulars of stock in =tblMucJOB field >>>[City] Nawabshah...
  2. S

    Stock Reporting

    I have created four tables with relationship of One to many - tblMucadamJOB, tblMucadamDta, tblMucadamInvoice and tblMucadamStkRprt. We open a job which remain with us for a year and required every day reporting tblMucadamStkRprt (table) .. 1st report with opening balance and then all other...
  3. S

    Monthly Billing / Invoice

    I have created four tables with relationship of One to many - tblMucadamJOB, tblMucadamDta, tblMucadamInvoice and tblMucadamStkRprt. We open a job which remain with us for a year and required monthly billing tblMucadamInvoice(table) .. The billing information could be fetched from tblMucadamJOB...
  4. S

    MS-Access Database, Forms and report generating

    I am a beginner and new to this forum, need help to create form and report. My task is to create database with forms and reports, where, we open New Jobs and each jobs remains with us for 1 year. Same times, we invoice it on monthly basis where we maintain the every day stock reporting for it...
  5. S

    How may I use Count and Sum in Union Query

    Hi all, I have created Union query based on two tables tblValAset and VhclAprs, got stuck, how may I apply Count and sum in this union query? ----------------------------- SELECT ReportDt, BnkNme, BnkCod, SrviceChrgs, RecdAmt, TaxDeduct FROM tblValAset UNION ALL SELECT ReportDt, BnkNme...
  6. S

    Multiple labels could be change with on go.

    Hey All, I am trying to create several forms where I will place Title (lable) company name. Is is possible in access 2013, if I change somewhere the name of company and it should change all labels with the same company name? If is it possible please let me have the solution how may I apply...
  7. S

    Forgot Database encrypted password

    I Forgot Database encrypted password:banghead:, how can I sort this issue out? Please help
  8. S

    User Defined Auto generate invoice number

    Hello every on, I am the beginner of access 2013, stuck with one assignment need your wonderful help please. My assignment is, when I start to fill the form, it should fetches the information based on data entered in some of its fields to autonumber field called InvoiceNo and result should...
Top Bottom