Search results

questions There are no dumb questions if you don't know the answer!!! Thats what these forums are for. Glad you made it work. jim

query criteria grant, I use accesss97 so I can't see the templates and I am not familiar how the templates work in relation to a report. Did you try using a query and base the report on it? The only other suggestion i have would be to try to disect the template to see where and how the criteria...

paramaters scott, if you put the "Between....." in the criteria section of the query grid of your date field and your form is based on the query, a parameter box should appear when you open the form prompting for the "start date" and "end date" jim

queries grant, again, try a query. Follow the "new" query method selecting all the fields you need for the report. In the criteria section of the query grid under your "Datefield" type; Between [Startdate] and [Enddate] (Or any text you want between the braces) Run the query and enter the...

query grant, Don't know if you solved this or not. I noticed another post about parameters. I will try to answer that one after this. Have you used a query? Try a query "new" and pick "simple query wizard" in the "tables/queries" choose WorkorderByCustomer and then select the fields you want...

exodus, This solution works very well for me. Add a table to your database that only has one number field. Populate this table "Number" to contain sequential numbers 1 to whatever the maximum number of labels you would ever print. Add this table to the query that is the record source for your...

Oliver, Almost forgot. This is a routine described by CosmoKramer on a different forum. If the "numbers" table contains as many numbers as your [field]*2+1 maximum then the between 1 and [field]*2+1 will work. Have had many requests for this type of routine. jim

Oliver, end of the between clause; Between 1 and [Quantityfield]*2+1 and see if it gives you the correct number of labels. jim

oliver, I have tried and tried to get the *2 + 1 to work... I can get the figure but referencing it to the "Between" criteria has got me stumped... In a blank QBE field i placed [quantityfield]*2+1. It, of course, gave me the correct number but I cannot for the life of me figure out how to...

Your "quantityfield" should be the field that you have for the number of labels you want printed. That should eliminate the need for entering a parameter value. jim

Number of units to print The description below gives the following results; ( I noticed in the preview that the numbers do not line up with the columns...) item quantity Number chair 1 1 table 5 1 table 5 2 table 5...