Search results

Hi, After some help if possible. I am trying to obtain data for the last two full years are current year. So, i need the query to show data in this case for all of 2014, 2015 and current YTD. The criteria below doesn't seem to work - any ideas?

Hi, I am trying to allow the user to click a command button which will then attach all documents held within a specific folder to an attachment field in the database. I have managed to write the code to a specific file within a specific folder, however, i need to be able to attach all files...

Hi, OK, so I know how to search for a file using the dir function, however, i need to search for a file from a main folder which may have several sub folders. I am having no luck so far - i understand there is a recursive search facility but im not sure how i can get this to work with what i...

Hi, Im 2 years into my database however this is really getting to me! :mad: Im trying to find and open a folder based on a text box. The problem is folder could be in many sub folders which is hold on our J:\ drive. To further complicate, the folder i am searching may not be exactly as the...

Hi I have been trying endlessly to get this working but to no avail. I have looked and used sample codes posted on the net. Im trying to get top 1 [route_list_code] per [works_order_number] I have attached three images: - Query as isQL code - Query with top n in criteria (pulling wrong...

OK, i thought i had finally understood loops but this seems to be my downfall! Before i ask my question, i am where i am as this is the only way i can go about getting the data...I have attached an image of what i am trying to achieve so here goes: I need to add data from one subform to...

Hi, Im trying to create a loop that goes through each record in a continuous form which then stops when a checkbox value = 0. At this point another checkbox value = -1 in the header. If all records have a value of -1 then the loop stops at the end of the recordset. This is the code i have...

Hi I have created an advanced database which a site of 70 odd people use however im trying to create something which i believe should be relatively easy but appears i may be trying to hard to make it work! I have attached a department matrix as an example of what it currently looks like...

Hi I have a large database which runs various reports however i am struggling with the last bit to get this report working. Under each "Works Order" is a set of scrap which is associated with this batch. Instead of rows of data i would like to add all the "reason for scrap" to a single text...

Hi, I have a bit of an issue with this top N per group which i understand has been talked about on many occasions however i just cannot get this to work. The code i have entered is as follows: SELECT [1QryComplexityDelivery4].Year, [1QryComplexityDelivery4].Month...