How do i create a report whoms data is dependant upon a question?

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

Guest

I want to be asked a question e.g. 'enter the nme of the person you are
looking for' and then when i enter the name a report is created showing the
information about the person whos name i entered (from the database).

I believe you can do this using a quiery?

Any help is much appreciated
 
Calum112 said:
I want to be asked a question e.g. 'enter the nme of the person you are
looking for' and then when i enter the name a report is created showing the
information about the person whos name i entered (from the database).

I believe you can do this using a quiery?


You can use a parameter in the query. Just use a criteria
for the name field something like:

[Enter Person Name]
 
Marshall Barton said:
Calum112 said:
I want to be asked a question e.g. 'enter the nme of the person you are
looking for' and then when i enter the name a report is created showing the
information about the person whos name i entered (from the database).

I believe you can do this using a quiery?


You can use a parameter in the query. Just use a criteria
for the name field something like:

[Enter Person Name]


Okay, then how do i make it create a form dependant upon the answer to the
question? - I'm a complete newbie concerning using access :)
 
Calum112 said:
Marshall Barton said:
You can use a parameter in the query. Just use a criteria
for the name field something like:

[Enter Person Name]
Calum112 said:
Okay, then how do i make it create a form dependant upon the answer to the
question? - I'm a complete newbie concerning using access :)


You lost me. Queries don't create forms, you have to design
your forms to display the results of a query.

These forums are not an appropriate venue for tutorials,
they are best used to ask specific questions that require a
relatively short answer or a pointer to a Help topic or web
page that can get you going. In this case, it sounds like
the best I can do is suggest that you take a course or read
a book on getting started in Access.
 
Back
Top