UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Closed TopicStart new topic
> Repost Topic ( Add Blank Lines On The Report), Access 2007    
 
   
phil_andre
post Dec 23 2017, 02:46 PM
Post#21



Posts: 220
Joined: 7-December 16



Hello Joe,

here is my design query for my rpt_MR print output.

SELECT tbl_MR.MRID, tbl_MR.MRDate, tbl_MR.ProjectName, tbl_MR.ProjectNo, tbl_MR.DLocation, tbl_MR.DDate, tbl_MR.PBName, tbl_MR.QuoteRef, tbl_MR.QuoteDate, tbl_MR.GLAccount, tbl_MR.SupplierName, tbl_MRDetails.ItemID, tbl_MRDetails.ItemCodeSys, tbl_MRDetails.ItemCodeStr, tbl_MRDetails.ItemName, tbl_MRDetails.ItemCatID, tbl_MRDetails.ItemTypID, tbl_MRDetails.ItemLoc, tbl_MRDetails.ItemUnit, tbl_MRDetails.MRQty, tbl_MRDetails.Remarks, tbl_MR.PBDate, tbl_MR.Note, tbl_MRDetails.MRDetailsID, tbl_MRDetails.MRDetailsID, tbl_MR.PBTitle, tbl_MR.MRNo, tbl_MR.PriorityID, tbl_MRDetails.Rate, tbl_MRDetails.Total, tbl_MRDetails.LevelCode, tbl_MR.Curcode, tbl_MR.Discount, tbl_MR.AppMR, tbl_MRDetails.DeliveryTime, tbl_MR.ApprovedBy, tbl_MR.PBNameDT, tbl_MR.MRDateDT, tbl_MR.EmailApproval, tbl_MR.PBCode, tbl_MRDetails.DNRef
FROM tbl_MR LEFT JOIN tbl_MRDetails ON tbl_MR.MRID = tbl_MRDetails.MRID;


how to apply that extra line here... i added your extra line table in my table. , it would be great if i can run like this in VBA code, coz sometime i am adding IF condition on command print.

Please help.

thanks.
Go to the top of the page
 
RJD
post Dec 24 2017, 06:56 PM
Post#22


UtterAccess VIP
Posts: 8,948
Joined: 25-October 10
From: Gulf South USA


See your other, parallel, thread for my response to your issue.

Let's stop this thread, since responses are in the other thread now.

Joe
Go to the top of the page
 
2 Pages V < 1 2


Custom Search
RSSSearch   Top   Lo-Fi    21st October 2018 - 09:22 AM