Recent content by BlondeBimbo

The actual DB doesn't use lookup fields, this query has around 30 individual pieces of data around 24 of which are all from 5 sub-tables, the rest from the primary table But as I couldn't build one with two look ups, I produced the simplest DB example to illustrate the problem, as once I could...

Thank you, I was hoping you could build it using the Query builder. As it happens, because it wasn't working last week and I needed to get the report/data out to excel I wrote the thing in VBA - added a new table with the data I needed then added a widget. Pressing the widget run the VBA...

here is the actual DB and query

I did! This is the actual SQL I used using the actual names In the example DB I built just for this test SELECT Movements.Moved, T1.Location As [From], T2.Location As [To] FROM ( Movements LEFT JOIN Customers AS T1 ON Movements.FromCustomer = T1.NameC) LEFT JOIN Customers AS T2 ON...

? well things isn't the name of the real table, just the example above I am using it for test,

Ok so I basically deleted the query and used SQL directly, Access accepts this but it doesn't work I just get cmd boxes requesting Things.FromCustomer, T1.Name, Things.ToCustomer, and T2.Name;

Thanks, how would I enter that via the query builder, can you use overwrite the SQL? I did try writing in SQL but it reverted to the SQL as generated by the query builder/design view

Hi New here, just joined, fairly OK with code (Such as VB, C++, and Python etc) however SQL not my strong point. I use access to keep track of things in my business, building a database with quite a lot of VB code behind the forms etc. This was built some time ago, and I only occasionally...

I am struggling to create a query in access. I have two tables say “Things” which contains the fields, Moved, fromCustomer and ToCustomer with a couple of entries such as bananas (moved) Customer1 (fromCustomer) Customer2 (ToCustomer) apples (moved) Customer3 (fromCustomer) Customer1...