Report Prompt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've searched through some of the posts and have seen some questions that
somewhat relate to this, but they all seem to deal with date parameters.

I have a database that contains thousands of loan numbers. Users needed a
report they can run to show the findings of certain loans that are in a
certain status, ONE loan number at a time. For example, the query will only
choose loans that are in a "repurchase" status, but then the user needs to be
able to run a report off of that where the report will ask them which loan
number they want to run it on. So, I created a query containing the fields I
would need that will only pull loans in "repurchase" status, but I don't know
how to set the report up to ask for a loan number when the user tries to run
it, so it will only run the report on that loan number. Then once closed, it
won't need to save that info, a user should be able to open it again, have it
ask for another loan number and do it again, etc.

I feel like I didn't explain this very well, I'm not a very experience user,
but hopefully one of the experts out there can help me!
Thanks much!!!!
 
setup a query with all the desired fields, then set the criteria for the
Loan Number field to:
[Enter Loan Number]

as for the repurchase piece, you didn't explain what type of table field
this is. if it is a yes/no field then just add the criteria for the field as
True or False in your query. (More details would be helpful)

run the query and it will prompt you for your Loan Number and return the
results. (It won't save the results and will prompt you every time you run
the query).

Also I would create a report based on the query after you create it.

_Bigred
 
Back
Top