Search results

Yes I understand, I'll redesign the query method. Thanks for the link

OrderIDMinimum is a query on a separate table to identify the start of the orders I need from the workings table. It runs locally and is immediate when run on its own. I ultimately want to create a table that will only show the workings of orders >= orders from a specific date. (I am testing on...

SELECT workings.* FROM workings, OrderIDMinimum WHERE (((workings.ORDERID)>=[OrderIDMinimum]![MinOfORDERID]));

Hi All I have an ODBC linked table to a topspeed database(:() that I want to get data from. When I create a query where I enter an actual number(e.g.>=12345) in the criteria of ORDERID column, the query gives me the results immediately. If I look up a different small table for the minimum...