Create blank rows in query

[Amy Blankenship]

I am working on a course where people taking the course can ask a variety of
people questions. Each person has a default number of questions they can be
asked. For the purposes of populating a form with the right default number
of answers, I want to create a left join on a dummy query that has more than
enough records in it and return the top n records, depending on the default
number of questions. I know this is possible in VBA, but I'm at a loss as
to how to specify the top n records in a query.

Thanks;

Amy

 

[Jeff Boyce]

Amy

Open the query in design mode. Select properties. Use the "Top" property
to set either percentage or number.

Regards

Jeff Boyce
<Office/Access MVP>

 

[Amy Blankenship]

So, Jeff, is there any way to have the query take the TOP number from the
integer in a field of a table row? That's what my question was.

Thanks;

Amy

 

[Jeff Boyce]

Amy

It sounds like you need to dynamically modify the SQL statement, based on a
field value in a table. I suspect you'll need to write a function that
dynamically builds a SQL string, then runs it.

Regards

Jeff Boyce
<Office/Access MVP>