Search results

Thanks spikepel, I actually solved this one! I went and had a look at my backup and I saw that some of the fields in my table had the data type number so I changed these fields back to number in the current database and it worked - don't know why as the entries are 'yes' or 'no' but hey, at...

Hi all, I have a table 'Project Details' to which I have recently added a new field 'Last Invoice issued'. This field is a text field with a lookup and will default to 'No' for new records being added. When the related record is updated in my 'Invoices' table, I have set up a query to change...