Recent content by Samadkhan

Hi all, I have attached table relationships snap and hope it may helps to sort my issue. Thanks all

Hi all, I have attached table relationships snap and hope it may helps to sort my issue. Thanks all

Thank you very very much for your wonderful help , highly appreciated

Thank you very much, highly appreciated ..

some data are unchangeable (in Label) where few are such as "Client Name" and "Address" [tbl >>>Fields]... Please advice with thanks

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...

same here, I want to create a button which should perform this job, any codes? please help me out with thanks...

I want to create a button which generate the report, is there any codes to perform this job? please help me out with thanks

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...

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...

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...

Great!! The result is according to my needs. Now the question is how may I use both queries in my summary report?... I tried to use both queries in my report, and, seams the wizard can not connect both in my report... I need report to be in following pattern where I would create an...

I tried the following Union Query (SQL) where I used Count and Sum (Total). The result is almost according to my needs, however, it's applying separately on both tables. If it apply on both table equally then I may be able to get my result according to my needs from one union query... SELECT...

Dear, The following is my union query I wanted to create summary report based on ReportDt and BnkNme to calculate the SrviceChrgs-RecdAmt-TaxDeduct=Outstandings << New Field. Please help with thanks.. SELECT ReportDt, BnkNme, BnkCod, SrviceChrgs, RecdAmt, TaxDeduct FROM tblValAset UNION ALL...

Thank you very much, Now it's working the ways I wanted. However, how may I use Date filed with this query to generate summary report? Please help thank you!