Search results

Thank you, can you explain how/what the queries qryDatesFromMsysObjects and qryNumbersFromMsysObjects are doing? Trying to educate myself here.

Thank you, but I have no idea how to achieve that. Can you assist me further?

Good Morning and thank you for previous assistance, I'm fairly new to Microsoft Access and struggling to write a query. I have a simple table containing all issues made to the customer (sample data attached). What I'm trying to achieve is a query which displays the number of times a part is...

Thank you for your response. Once the complete CSV file is imported into a table how would I go about writing a query to filter based on the criteria I provided? Is that even doable? I'm trying to automate a process which at the moment is very time consuming and open to error.

I have a CSV file with multiple 'columns' of data I want to import into an Access table however I would like to filter which records are imported based on the contents of one field. I've attached a sample set of data to hopefully assist in explaining what I'm trying to do. In the sample data...