Search results

Ok, I understand the importance of good field names. I take the option of putting brackets around the poor field names. My raw data is not in Access, I linked a few Excel tables in order to make my database running. Still, I have the problem, that the query in SQL is not working. The current...

Hi Plog, thank you for your files and the useful comment. I read the code in the SQL view. and I updated it according to my specific needs... Now I copied it to my actual database, and updated the field names. When I write the following code in the SQL view, the query runs fine: SELECT...

Thank you Cronk and plog! I appreciate you are thinking with me. Instead of macro, I should have written 'query', my typo. I am building a system that follows up if the invoices are issued with the correct price for the sold product. Is the price applied on the invoices in accordance to what...

Hi, I am trying to make a query that shows the price for a product, based on two parameters. Parameter one is a product code. Parameter two is a date. This date falls between two dates. I have one list (table) where is product code and invoice date. The second list (table) I have, contains...

Hi there, I'm Paul born and raised in the Netherlands, but now living in Finland. Currently I am learning how Access can make my work related tasks easier. I have already a nice basic knowledge about tables, fields, queries and expressions. But to make my work easier I can use some insider tips...