'This expression is typed incorrectly or is too complex' 1

[beredon]

I get an error when I try to run this query in Access. It doesn't look too complex to me

PARAMETERS storyid Short;
SELECT story.story_id, story.story_date, story.story_text, member.member_name_first, member.member_name_last
FROM member INNER JOIN story ON member.member_id = story.story_author
WHERE story.story_id = "storyid"

I can't seem to see where the problem is. story_id is the primary key in the story table and member.member_id is the primary key in the member table.

 

[tlbroadbent]

I think the error is in the Parameter statement. What is the meaning of Short? That field should be a data type and I don't know of a data type named "SHORT."

Another problem may be in the Where criteria. Is the column story.story_id numeric or text? If numeric, don't enclose the criteria in quotes.

WHERE story.story_id = 999 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[beredon]

Thanks a lot, it was the quotes causing the problem!