Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

access


  • Please log in to reply

#1
rivekm

rivekm

    Member

  • Member
  • PipPip
  • 65 posts
Hello,

I have created a form with names in it. I want to be able to run reports but I would like to run the report on a particuliar person and not run it on all the records. I have not been able to figure this out. I can create a form by filter and then create a report that way, however I know there must be an easier way of doing this? So lets say the last name begins with "G" and I want all the records G has entered. Any idea on how to run the report to pull just the records G had issues with?
  • 0

Advertisements


#2
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
Hi rivekm,

Your form should be based on a recordset (Table or Query), which is probably a query. The best solution most likely is to base the form on a Parameter Query. What this will do, is when you open your form or run the report it will prompt you by way of a dialog box to enter the parameter (Criteria) that you want the the query to be based on.

So for example, if you want the dialog box to prompt you for a name in the Field Surname

Open the Query in Design mode
In the Criteria section of the Field Surname type [Enter Surname] Note the square brackets around the criteria.

This should do the trick for you. :whistling:

Look up "create a paramater query" in the Help section, it should give you all the neccessary info.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP