Search results

No luck, if it's a clue, if I do a normal 'Find' on the date field with 06/10/10 the record is found, if I put date() in the same 'Find' it reports it's not found. Thanks again

Hi Thanks for your reply, I've put the code into the 'On Click' event of a button and changed the [DateField] with my field name [Date_Worked] but when I click it doesn't move to today in my records. Thanks for your help Alan

:D Hi Guys I've got a subform (frm_Date_Worked) with lots of records with consecutive dates in one field [Date_Worked]. I need a button on the subform that will go to the record with today's date. I've been looking at 'DoCmd.GoToRecord', but I can't get it right. Thanks for your help. Alan

Thanks, but I can't seem to get the syntax right, I'm working on it

I have totals in a report that work fine if there is a record entered that meets the criteria for the report, but if there is no record, the result of the unbound calculated field on the report is #Error, What do I need please ?

Thanks for that, I thought I was going mad. Alan

Sorry to be an idiot, where do I find that sql code please. Thanks

test.mdb attached Thanks for your time. I've zipped a test.mdb, in my testing I tried this very simple mdb to prove the fault. 3 tables, 1 master, 2 sub, joined the table1 ID field to the foreign keys in tables 2 and 3. The made a query, as soon as I add the 2nd sub table and view the query...

Thanks for your reply but, But this happens if I only have one master table and two sub tables. Thanks

I've got a table with Vehicle_ID as the Primary Key and four other tables with Vehicle_ID as a foreign field for joining. When i try to make a query based on the master table with the sub tables linking it with a one-to-many join, i lose the ability to add data to the query. I only have to add...