Search results

thanks Pat ..I shall try this and post back..cheers Fi

Hi I have looked through previous posts on this subject without being able to find where I am doing wrong, MainRpt has a calculated control, which is a nested IIF, [DlvdNet] SubRpt has a field [InvVal] (there can be many InvVal for each DlvdNet as each DlvdNet can have many invoices billed...

ok ..thanks again:D

Hi This seems to work equally well, is their either one you would recommend to be better to use for any reason ?? Thanks again you have helped me in the past and it is much appreciated Cheers Fi

Hi Rural Guy This seems to be working - varResult: IIf(IsNull([InvoiceValue]),"£0.00",[InvoiceValue]) and Liability: [NetToVM]-[varResult] Thanks you so much for your help on this I was going about it in a very long winded way...I will of course get back to you if it isnt working as well as...

Hi I tried the Nz() function examples in Help and the one you have give above using IsNull used them as expression in the query that the report is based on they all gave a result but only in 'InvoiceValue' already had a value in it ie that some data entry had been done in the frm/tbl Invoices, I...

Nz() Function Hi I have had a look at the function and understand what it will do I believe but am unsure where to put it ..I tried it on the Invoices form but it seemed to have no obvious effect, which Im sure will be clear to you why when you see what i tried below. Is what it should be...

Hi Rural Guy No but I will do now ..thanks for the pointer ..Fi

Hi I have a DB that i use to record Purchase Orders each PO can have many Bookings and each booking can have many Invoices logged against it, this has been working as I wanted it to until I started to build reports from the info entered. The main thing the reports do is show the liability...

Hi Pat Again many thanks for your reply I will try that and see how I get on..cheers Fi

Hi Pat Many thanks for your reply that works perfectly thanks for your help, I am now having a small problem in that if an order has more than one invoice when I sum the totals on the report it sums the value of the order twice or for how ever many invoices are allocated against that order, I...

Hi I have a purchase order and billing DB which when I receive a supplier invoice relating to the purchase order I go to the line on the order it relates to click on a button which takes me to a related form SupplierBilling where I can enter the invoice details. The DB is also 'almost' ! set to...

I Hi Dennis Your suggestions sounds good would you be able to give me a couple of pointers on how to do this .. thanks fi

IIf Hi Keith I seem to be able to get to 9 statements before it stops working could you point me in the direction of where I could find info re Switch functions I have looked her but still havent been able to work it correctly thanks for your help Fi

Hi I have quite a few IIF statements in queries on forma and reports which have been working however I am tring to add more variables into them and am getting messages saying they are too complex, ideally I would like to be able to get them into code (I think, would this be a better way to deal...

Hi quilter Just wondered if you had found the answer from the various responses posted if you haven't I would be happy to have a look at your db to see if I can come up with the code for you ...learning curve for me also so wouldn't mind giving it a go Fi

Hi Dennisk was your response for me ??

IIf .. Hi Here is what I use for what looks like a similar calculation, it goes in the query that the form/report is based on, I have attached a screen print to show where it goes CPMCalc: IIf([CPM]='CPM' And [%Delivered]<90,[DeliveredImps]/1000*[OnlineCP], IIf([CPM]='CPM' And...

numbering list Hi Epic thanks for your reply, I dont think this will work for me though as if I were to use the POrderID auto number I would not be able to give each line of the POrder ( the 2 tables in use are POrder and POrderDetail) an individual inv number ie no matter when the individual...

Hi I have a purchase order database that I also create customer invoices from, each line of a particular order can have either the same or a differant invoice number. Within the DB there are 4 types of media billable all of which I would like to use the same numbering system ie SI00001 onwards...