Recent content by randallJ

Thanks both solutions are great.

oops sorry it was Zografski's solution.

Thank you all for your repies. David I have used your solution as it allows me to append to a text file after each record has been evaluated. However is there a way to force a carriage return after a line of text has been appended? Basically I am recording the details of those records that have...

Hi I have a program which evaluates a database and changes the value in a field if an expression is true. Everytime the expression is true I would like to send the record number and other information from various fields to a text file. What is the best way of doing this?

Thanks jrbbldr I will look into these. Jimstarr Yes this works, I did think of trying this, but dismissed it! Thanks a lot.

Sorry Imaginecorp I had not seen your response yet, I will run through your code now. Thanks

Jimstarr Thank you for responding. I have removed GO BOTTOM and achieve the same results, the whole purpose of the program is for it to append blank so I cannot remove this, is there a way around this?

I have two tables a and b. A contains numbers 1-10, b contains numbers: 1,1,2,3,3,4,5,6,7,8,9,10. I want to compare the records in a against the records in b. If they match then *do something. so far I have this however it will not append if there are multiple instances of the same number in b...

Thanks all - I had tried various combinations of ctod() but always got the "argument mismatch" error.

Hi This is probably really easy but can't seem to get my head around it. How do you clear a date field. E.g a date field has an existing date in it and I want to remove that date and make the field blank.

I have checked Constant Band Height and it is not checked. If the objects are not blank then I need them printed on a new page and as such have specified new page with group change. Could this be why it does not work.

Really?? Does it matter where the objects are i.e. detail, header or footer.

thanks boris but that did not work.

Is there a way to suppress a page in a report if it is blank. For example I have put print when conditions on fields in a multiple page report, If the conditions are not met a blank page is printed, is there a way of telling it " do not print page if blank

Thank you all for pointing me in the right direction. Looks like I need to start reading!