Search results

See attached for zipped db.

The SQL statement is: INSERT INTO [Movements-Detail] ( [Ref No], Stockcode, Quantity ) SELECT [Temp Write Back].[Ref No], [Temp Write Back].[Component Stockcode], [Temp Write Back].Required FROM [Temp Write Back];

Hi Sorry I'm a bit of an Access dunce sometimes - (and don't do the complicated programming stuff :)) - I'm trying to run an append query to add some records to another table. Ref No - short text Stock Code - short text Quantity - long integer Both tables only have three fields as above and...

Hi I consider myself a reasonable Access user - but am certainly not a programmer. I'm trying to write an inventory/stock control database (or modify an existing one) - I wrote one a few years ago but it was v clunky so want to improve this time around! The system needs to record component...