Search results

Thanks for all your help JHB that works great, this problem is now solved. I can now get back to the real world after going around in circles. Just to summarise what I had wrong for anyone else looking. The code needed is...

Hi JHB I have the scaled down Db attached. Open form frmSuppliersTransSub Click button on top left "Full details" The sub form uses query qrySuppliersSub Which is the one I am having problems with. Thanks for your help

Thanks for your help. As I can't get it to work I will take you up on your kind offer. I will extract the relevant parts and send them. Thanks

Hi Thanks for every ones support and help. AlexN Thanks I did a compact and repair and had some success as I now have errors reported which was not the case. I have extracted the table form and query to a new database to allow more experimentation and to remove any interference form other areas...

Problems using IIF with Dates as criteria in a query I am trying to use a IIF command in a query with date functions but can’t get it to work. I am trying to limit a list of Suppliers to a choice of all or the last 3 months. I have the following 2 parts working when used alone as criteria...

I am retired in Spain and have written a few databases both in the UK and here in Spain. I am familiar with Access and VBA but not at a high level. I tend to learn by trial and error and help from sites like this one. I don't think I am good enough to give advise but will certainly like some...