Search results

Hi I have a crosstab query with one row heading and lots of column headings that show over several pages. Is there a way of having the row heading appear at the start of every page? Thank you

Hi I have created a simple query to show pattern requests from a trade show set out as follows:- Cust No. Name Pattern Comments SGE1 Kinga NJ42-1 All SGE1 Kinga NJ59-5 All SUK4 Jones NJ42-1 Col 3 To make this easier to read/pick i created a crosstab query from...

Hi I have a query which includes a calculated field as follows: Free Stock: Nz([Total Stock],0)-Nz([SumOfKg],0) In some cases this returns a negative number and I would like this changed to a zero. I have tried the following in the criteria IIf(Nz([Total...

Hi I work in a small company warehousing yarns ready to be woven into fabric. I have created a simple stock database, and can enter customer orders with an estimate of all different yarns required for each fabric. (not an exact science unfortunately) So i have queries/reports of total yarn in...

Hi I have created a report to show outstanding orders which consists of a main report with customer details, a subreport showing the order details and a second subreport (within first subreport) showing further details regarding components needed for those orders (name of component, on order...

I have created a report for a packing list which shows:- C/no., Order No., Details, Net KG This has to show all details, ordered by carton no. After all details are listed I want a summary at the bottom of the page ordered by order no. Order No., Details, Sum of Net KG, Gross KG(this is picked...

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...

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...

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...