Parameter query

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

Guest

I posted yesterday regarding a parameter query. I realized that what I was
hoping to do wouldn't work simply b/c what I wanted to do (Enter the name of
a breed) was being stored as a number. I'm not sure if there's an easy way
to fix this.

I took the example listed at:
http://office.microsoft.com/en-us/assistance/HA011170771033.aspx?

I created a parameter query and then a form to supply the parameters to the
query. It is saying that I cannot run the query. I'm guessing because of
the fact the Breed is being stored as a number. Here is the query:

SELECT tblAdopter.PetName, tblPetInfo.Breed, tblAdopter.LastName,
tblAdopter.FirstName, tblAdopter.AdoptionDate
FROM tblPetInfo INNER JOIN tblAdopter ON tblPetInfo.Name = tblAdopter.PetName
WHERE (((tblPetInfo.Breed)=[Forms]![Breed Summary Form]![Breed Name:]) AND
((tblAdopter.AdoptionDate) Between [Forms]![Breed Summary Form]![StartDate]
And [Forms]![Breed Summary Form]![EndDate]));

Before I worked it into the form. I could run the query fine by entering
the corresponding number to the breed.

Any help would be great, thanks!
 
woods1119 said:
I posted yesterday regarding a parameter query. I realized that what I was
hoping to do wouldn't work simply b/c what I wanted to do (Enter the name of
a breed) was being stored as a number. I'm not sure if there's an easy way
to fix this.

I took the example listed at:
http://office.microsoft.com/en-us/assistance/HA011170771033.aspx?

I created a parameter query and then a form to supply the parameters to the
query. It is saying that I cannot run the query. I'm guessing because of
the fact the Breed is being stored as a number. Here is the query:

SELECT tblAdopter.PetName, tblPetInfo.Breed, tblAdopter.LastName,
tblAdopter.FirstName, tblAdopter.AdoptionDate
FROM tblPetInfo INNER JOIN tblAdopter ON tblPetInfo.Name = tblAdopter.PetName
WHERE (((tblPetInfo.Breed)=[Forms]![Breed Summary Form]![Breed Name:]) AND
((tblAdopter.AdoptionDate) Between [Forms]![Breed Summary Form]![StartDate]
And [Forms]![Breed Summary Form]![EndDate]));

Before I worked it into the form. I could run the query fine by entering
the corresponding number to the breed.
Click to expand...

On the form "Breed Summary Form," what type of control is the control
"Breed Name" and what is its value when the query runs?
 
Back
Top