Recent content by JPW

No different than before. The dates are displayed, but still get that error message once saved as .PDF. It appears fine in the print preview, but for whatever reason something is going wrong.

I have a problem. At the moment I have a report that collects various data from query and 2 calender controls. Basically I have a macro button that is used with 2 calender controls. Once I select the Date From and Date to I then press the macro button to print a report - and that all prints...

That did work, but I always want to try a slightly different approach instead of using the job number field. I want to use the [date out] field and implememnt the 15% VAT calculation for everything over 01/12/2008. However, it doesn't seem to be working. This is the code...

Thank you very much - I shall try that.

where in that code do I refer to the 3 txtboxes that contain the relevant price data? [txtrecovery] [txtstorage] [txtextra] The existing code in the VAT txt box is: =[txtrecovery]*0.175+[txtstorage]*0.175+[textextra]*0.175

I have a form on a database that consist of many fields, and part of it has 3 fields that are: - Recovery Price [txtrecovery] - Storage Price [txtstorage] - Extra Items Price [txtextra] All of these are NET prices and I have a VAT (or sales tax in the u.s) text box that performs a...

Thank you I'm so sorry, I was putting the iif code into the criteria box and not the actual field. It all works now thank you!

Okay, I tried Brian's soloution, but not fully working. The paramater box no longer appears, but no results show up in my query. I had a column in the design view of my query called 'Disposed' This did not link to any table so was kinda unbound. Then as soon as I leave the field, Access...

I've tried =IIf([collected by]="AUTOSALVAGE","YES","") However if false i don't want any text to be displayed. I'm only interested in the "YES" yes part of things. When I mean it's not working, I mean I get the 'Enter paramater value box'. So Imusst be doing something wrong

I have a field in my query called 'Disposed', but it is unbound so it also has the text 'Expr 1' next to it, as no point having a field in the table in my database to save space. Anyway, I also have in my query the field 'Collected by'. I have in the criteria of my 'Disposed' coloumn the...

Sorry, it's working. Perfect - thank you very much.

No still no luck :(

No. I still get the 'enter paramamter value' box everytime i open the report, and when in the report the box that contains the code is '0' I'll try and explain my report more just to make sure. Report linked to query. I have around 8 columns/fields. I have a column/field called 'Collected...

I entered the text 'fd' which is the name of the field that contains the word "Yes"...If there is no "Yes" in that field then that field is just blank. =Sum(IIf([fd]="Yes",1,0))

No not working, when the report is opened a box appeas asking to enter paramater value.