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    
post Dec 23 2017, 02:46 PM

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.

Go to the top of the page
post Dec 24 2017, 06:56 PM

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.

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

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