Search results

exactly :) Order 001 line 001 can have 5 different quantities on 5 different dates, i dont see how i could query in this situation? edit: would the SQL equilivent of a Dlookup be faster? (ie swap all my dlookups for sql expressions)

ooh, i'm really sorry, the whole point of the program is that the data cannot be queried properly (bad design of the guy before me) the schedule lines have no unique reference, the only reference is to about 5 of them at a time (the order and line of the order they are against) after that the...

right, i'd noticed a bit about "Recordsets" when i was working out the above, i guess i'll have to look into them more :/ you've lost me, the source of the variable is a date, and the variable is stored as a date, does the field it is writing to also need to be formatted as a date or do i miss...

i asked this last week: http://www.access-programmers.co.uk/forums/showthread.php?t=188857 after a lot of searches and thinking i managed to write the below which almost achieves the aims, i have two small problems still: first is that the line: DoCmd.RunSQL "update orderstab Set deldate =...

Edit: Read your signature Hi Dave, thanks for the reply, sorry i was not very clear, there are 3 order tables: Purchase Order Header (this has delivery information etc, key field is Purchase order number) Purchase Order Items (this has part numbers and prices etc, key fields are Purchase...

I have two tables, one of orders and one of deliveries, however if an order/delivery is scheduled I cannot compare the two easily as there is no unique reference (badly designed system I'm trying to work around :) ) we have Order number, and Line number, but not Schedule Line number, is there...