Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Need ideas for a search

Discussion in 'Information Technology' started by Daniel, Jul 28, 2006.

Tags:
  1. Daniel

    Daniel
    Expand Collapse
    Guest

    Hi, I wonder if somebody could give me an idea. I have this database with the
    information for various charities organizations. So each organization has
    name, address, phone, contact person, and many different services that they
    offer. On the table created for that, each service offered is a Yes/No type
    of field so whenever the info is entered for each organization, if they offer
    certain type of service the checkbox for that service should be checked. I'm
    having some trouble trying to create a report for it now. I need to create a
    report showing all the organizations that offer certain type of service. For
    example let's say I need to know all the organizations that offer Monetary
    Assistance. How can I create a search for it that will create a report with
    the details of all the organizations that offer Monetary Assistance?

    Any ideas would be appreciated.
     
  2. Loading...


  3. default105

    default105
    Expand Collapse
    Guest

    Well I am pretty tired but I will try to give the best answer I can. I see a
    lot of if's here but I will try to give you a basic idea. I would create a
    query with the fields from the table that you have that you wish to include
    on the report. In the query set the criteria to ="Yes" in the Monetary
    Assistance field and that should list all the information that you need. To
    check it just run the query. Now take your report and have the record source
    set to the name of the query and that is the most basic report setup I can
    think off.

    I hope this is what you were asking about.

    HTH

    "Daniel" wrote:

    > Hi, I wonder if somebody could give me an idea. I have this database with the
    > information for various charities organizations. So each organization has
    > name, address, phone, contact person, and many different services that they
    > offer. On the table created for that, each service offered is a Yes/No type
    > of field so whenever the info is entered for each organization, if they offer
    > certain type of service the checkbox for that service should be checked. I'm
    > having some trouble trying to create a report for it now. I need to create a
    > report showing all the organizations that offer certain type of service. For
    > example let's say I need to know all the organizations that offer Monetary
    > Assistance. How can I create a search for it that will create a report with
    > the details of all the organizations that offer Monetary Assistance?
    >
    > Any ideas would be appreciated.
     
  4. Daniel

    Daniel
    Expand Collapse
    Guest

    Yes that's how I basicaly was able to make it work, but it is not working for
    what I'm trying to to. Let me try to explain it better. I did exactly as how
    you suggested. The only thing is I will be getting the value of the criteria
    from a form. The user will never see a query or anything, he will only see a
    form with the possible services offered and he will pick one. So the query
    will read the criteria for each service field from this form and that's where
    it's not working. I inserted on the criteria of the field the code for the
    form, something like this: [Forms]![Search]![field01], this will enable the
    query to get the desired value from the field01 that's on the form Search.
    But if I do that for all the services, it means that every service would need
    a criteria and that's not what I want.

    It's kind of confusing I know but basically what I need is to create a form
    that will allow the user search the database by services offered with a query
    and display the results on a form... in other words the value for the
    criteria of the fields have to come from what the user selected on a form.

    Hope you can understand and give me some ideas.

    Thanks,

    "default105" wrote:

    > Well I am pretty tired but I will try to give the best answer I can. I see a
    > lot of if's here but I will try to give you a basic idea. I would create a
    > query with the fields from the table that you have that you wish to include
    > on the report. In the query set the criteria to ="Yes" in the Monetary
    > Assistance field and that should list all the information that you need. To
    > check it just run the query. Now take your report and have the record source
    > set to the name of the query and that is the most basic report setup I can
    > think off.
    >
    > I hope this is what you were asking about.
    >
    > HTH
    >
    > "Daniel" wrote:
    >
    > > Hi, I wonder if somebody could give me an idea. I have this database with the
    > > information for various charities organizations. So each organization has
    > > name, address, phone, contact person, and many different services that they
    > > offer. On the table created for that, each service offered is a Yes/No type
    > > of field so whenever the info is entered for each organization, if they offer
    > > certain type of service the checkbox for that service should be checked. I'm
    > > having some trouble trying to create a report for it now. I need to create a
    > > report showing all the organizations that offer certain type of service. For
    > > example let's say I need to know all the organizations that offer Monetary
    > > Assistance. How can I create a search for it that will create a report with
    > > the details of all the organizations that offer Monetary Assistance?
    > >
    > > Any ideas would be appreciated.
     
  5. BruceM

    BruceM
    Expand Collapse
    Guest

    I believe that what you need is to add to the criteria:
    OR [Forms]![Search]![field01] Is Null

    "Daniel" <Daniel@discussions.microsoft.com> wrote in message
    news:E8CE5055-2AC0-40E1-BACE-B898DEE08353@microsoft.com...
    > Yes that's how I basicaly was able to make it work, but it is not working
    > for
    > what I'm trying to to. Let me try to explain it better. I did exactly as
    > how
    > you suggested. The only thing is I will be getting the value of the
    > criteria
    > from a form. The user will never see a query or anything, he will only see
    > a
    > form with the possible services offered and he will pick one. So the query
    > will read the criteria for each service field from this form and that's
    > where
    > it's not working. I inserted on the criteria of the field the code for the
    > form, something like this: [Forms]![Search]![field01], this will enable
    > the
    > query to get the desired value from the field01 that's on the form Search.
    > But if I do that for all the services, it means that every service would
    > need
    > a criteria and that's not what I want.
    >
    > It's kind of confusing I know but basically what I need is to create a
    > form
    > that will allow the user search the database by services offered with a
    > query
    > and display the results on a form... in other words the value for the
    > criteria of the fields have to come from what the user selected on a form.
    >
    > Hope you can understand and give me some ideas.
    >
    > Thanks,
    >
    > "default105" wrote:
    >
    >> Well I am pretty tired but I will try to give the best answer I can. I
    >> see a
    >> lot of if's here but I will try to give you a basic idea. I would create
    >> a
    >> query with the fields from the table that you have that you wish to
    >> include
    >> on the report. In the query set the criteria to ="Yes" in the Monetary
    >> Assistance field and that should list all the information that you need.
    >> To
    >> check it just run the query. Now take your report and have the record
    >> source
    >> set to the name of the query and that is the most basic report setup I
    >> can
    >> think off.
    >>
    >> I hope this is what you were asking about.
    >>
    >> HTH
    >>
    >> "Daniel" wrote:
    >>
    >> > Hi, I wonder if somebody could give me an idea. I have this database
    >> > with the
    >> > information for various charities organizations. So each organization
    >> > has
    >> > name, address, phone, contact person, and many different services that
    >> > they
    >> > offer. On the table created for that, each service offered is a Yes/No
    >> > type
    >> > of field so whenever the info is entered for each organization, if they
    >> > offer
    >> > certain type of service the checkbox for that service should be
    >> > checked. I'm
    >> > having some trouble trying to create a report for it now. I need to
    >> > create a
    >> > report showing all the organizations that offer certain type of
    >> > service. For
    >> > example let's say I need to know all the organizations that offer
    >> > Monetary
    >> > Assistance. How can I create a search for it that will create a report
    >> > with
    >> > the details of all the organizations that offer Monetary Assistance?
    >> >
    >> > Any ideas would be appreciated.
     
  6. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    You need a different table structure and then it will be easy --
    TblOrg
    OrgID
    OrgName
    etc

    TblService
    ServiceID
    Service

    TblServiceOfferedByOrg
    ServiceofferedByOrgID
    OrgID
    ServiceID

    For your report, create a query combining all three tables and pull down the
    appropriate fields for your report.

    --
    PC Datasheet
    Your Resource For Help With Access, Excel And Word Applications
    Over 1175 users have come to me from the newsgroups requesting help
    resource@pcdatasheet.com



    "Daniel" <Daniel@discussions.microsoft.com> wrote in message
    news:B30E42B9-0365-4577-B0E7-EA843A6D2D59@microsoft.com...
    > Hi, I wonder if somebody could give me an idea. I have this database with
    > the
    > information for various charities organizations. So each organization has
    > name, address, phone, contact person, and many different services that
    > they
    > offer. On the table created for that, each service offered is a Yes/No
    > type
    > of field so whenever the info is entered for each organization, if they
    > offer
    > certain type of service the checkbox for that service should be checked.
    > I'm
    > having some trouble trying to create a report for it now. I need to create
    > a
    > report showing all the organizations that offer certain type of service.
    > For
    > example let's say I need to know all the organizations that offer Monetary
    > Assistance. How can I create a search for it that will create a report
    > with
    > the details of all the organizations that offer Monetary Assistance?
    >
    > Any ideas would be appreciated.
     
  7. StopThisAdvertising

    StopThisAdvertising
    Expand Collapse
    Guest

    "PC Datasheet" <NoSpam@Spam.Com> schreef in bericht news:YuEag.57$SX5.46@newsread1.news.pas.earthlink.net...

    --
    --
    > PC Datasheet
    > Your Resource For Help With Access, Excel And Word Applications 'Resource ????
    > Over 1175 users have come to me from the newsgroups requesting help '1175 users ????
    > resource@pcdatasheet.com


    --
    To Steve:
    No-one wants your advertising/job hunting here!
    Over 875 !! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

    To the original poster:
    Most people here have a common belief that the newsgroups are for *free exchange of information*.
    But Steve is a notorious job hunter in these groups, always trying to sell his services.
    And he is known here as a shameless liar with no ethics at all.

    Before you intend to do business with him look at:
    http://home.tiscali.nl/arracom/whoissteve.html

    Arno R
     

Share This Page