Search results

I have created a database to handle orders / stock for dyeing yarns. Background is we receive lots of different white yarns from company's to hold in stock. Each type of yarn will have different batches which need to be kept and recorded separately. These company's will then send us a 'dye...

Sorry haven't responded earlier I have been trying to work this out plus other things! I need to show decimals so can't use Integer. (Yarn is on cones and we wind to order per g). I don't want to have one table for all my ins and outs as I want to make it user friendly for other people and...

Thank you both. I shall give these a go.

Hi I have created a 'stock database' for yarns. I have a table of yarns with a connected table where I can assign a colour and an initial stock amount. I have then three tables with stock adjustments - an In table, a Sales table and a general Out table. For these three tables I have created...

Thank you GohDiamond I will give that a go :-) Re: John Big Booty - can't use this as it will show orders placed after 1st april but doesn't eliminate anyone who also ordered previous to this

I have a 'samples sent' table with fields, Customer No., Name, Country, Samples ID, Date Samples Sent. I want to run a query showing customers from USA whose first order was after 1st April this year. Obviously the USA part is easy but I don't know how to filter to find first order. Thank you

I have a report based on a query. I want to be able to print the report when I open the query and fill in certain fields (only printing details where this has been filled in). I would then like this report to be 'filed' or saved in it's own right and then when I open the query again these lines...