Hi all,

Good day. I need my query to return 37 records, even if the exact record is less than 37. For example, the query will search for my criteria and return few records. Say it is 5 records that matches my parameters. However, I need the query to give me 37 records. Which means 5 actual records and rest 32 is blank records.

How can I achieve that?

Thanks,
Maha

You're going to have to write the output of the query to a table. If the table is not 37 records long, you'll have to run an append query to append X blank records to your table until you get 37 records.

To prevent the original query from giving you more than 37 records to start with, set the query property "Top Values" equal to 37.

OK, now I'm curious. Why would anyone want a query to give 37 records even though the true output may be less?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

What is the basic need for that.

If you are having for the grid/window to display at a time.
Create tmp. table of displaying query fields only.
add first 37 or less from resultant query.
check for the no. of records in the tmp table if less add upto 37/no. of recors required.

Dear it is very simple that you creat a loop which runs 37 time and in this loop you display your record one by one by adding a recordset and using if statement that if recordset.eof then it should not move to next record and simply continue the loop
I think you got my point if no then contact me without any hesitation. I would like to help you.



Numan
--------------------------------------------------
Love is the most precious thing of this world. So find it and grab it!