Search results

Ok that sounds logical I wanted to add all the dates into query formula just behind the end date but it only worked with one date for example "Work Days: dhCountWorkdaysA([strdate],[EndDate],#12/24/2012#), this was fine it counted 17 days ...but once I wanted to do following...

Well as I have no VBA knowledge I have spit them into 2 queries and it works but I have difficulties to put hem together as if I use UNION ALL between them its shows again note "Query is too comple" or when I use UNION there is not the same number of columns in each of them. Any idea how to do...

Hi VilaRestal, Thanks for the SQL however when I came to Q14 message box popped up with note "Query is too complex" so most likely its too much to process it and there are at least another 30 fields to add and compare so don`t know if you have any other idea how to solve this but I would...

I have corrected the filed names after clause "FROM" according my names so it should work like this: SELECT Q1.Unique, 'ID' AS [Changed Field] FROM qryNewOld AS Q1 WHERE Nz(Q1.IDOLD,0) <> Nz(Q1.IDNEW,0) but once I click run it asks me to enter parameter value so assuming "Q1.Unique" isn`t...

Hi VilaRestal, Thanks you for the code Iam about to test it out. To answer your question yes supplier on the left side is referring to the same supplier on the right side. The only difference is that on the right side is the old data for this supplier from previous month and deleted and added...

Hi VilaRestal, I`ve already created query to look for new suppliers as well as for deleted one and put them together into one query called "qryNEW=OLD". Attached you will find an excel example with executed and pasted query. Note that grey header columns refer to query headers also first 3...

yes exactly fields and structure is the same only data are different, fields are related to suppliers setup so need to count how many changes have been performed during a month. Thanks and regards

Hello all, As Im just beginner in access and related stuff I would really appreciate your help with my problem which is lasting for a few days already. Im working on a changes report and my purpose is to look for changed data in table from last month compared with current one. Previously I used...