Recent content by DougS

create a parameter query instead, and set criterea for Contract type to make you type something in = [Select Contract Type]. Only 1 query is needed.

Create a Crosstab query using product for your heading and set to do a sum for amount per date.

Probably my fault, but I don't think that I have explained my database properly The user form has these fields RecordId, Date, Week No.,Reject Note No., Weight, Customer, Width, Film Type, Department, General Fault and Specific Fault. A seperate query works out the value of each individual entry...

A brilliant answer. I have created in my original table for [film type] a seperate field for each years and the respective price per kilo, and deleted all thee other tables I created that are no longer in use. In my original calculation query I have deleted the date restriction, and created a...

You could use 1 text box only and type =[Start Date] & "-" & [End Date] This will put in the 2 dates with a - in between them

You could create a "simple query", and in design view, right click and go to "add table", and from the list add all the tables or queries that have the info you want to display, then simply drag each filed from the tables or queries one at a time into your new query in the order you want them to...

My database is used to store data for internal rejects, and to calculate the cost of each new entry I created a query, which takes the [weight] from the entry form, and multiplies that by the [film type](from a seperate tbl that holds all the different film types and their price per kilo). The...