Error Setting up Query

[bishmedia]

Ive built a query based on a table, code is

SELECT Freespace.[ID], Freespace.[Date], Freespace.[Aisle], Freespace.[Quantity], Freespace.[LFIE], Freespace.[LEIF], Freespace.[CountError], Freespace.[EndAccuracy], Freespace.[WeekNo]FROM Freespace;

When I run this it's fine as below.


If I want to filter the 'Week-No' using the 'WHERE' clause eg

SELECT Freespace.[ID], Freespace.[Date], Freespace.[Aisle], Freespace.[Quantity], Freespace.[LFIE], Freespace.[LEIF], Freespace.[CountError], Freespace.[EndAccuracy], Freespace.[WeekNo]FROM Freespace
WHERE (((Freespace.[WeekNo])=[Week-No]));

I keep getting the following error????


Am i missing something??

[ranman256]

Use a form,
in a textbox, txtWeekNo..

select * from table where [weekNo]=forms!myDorm!txtWeekNo

[bishmedia]

Really.....

Where do i put this??
select * from table where [weekNo]=forms!myDorm!txtWeekNo

[June7]

Build a query with query designer. The example is a dynamic parameterized query.

[bishmedia]

I sussed it, the WeekNo field was setup as a 'Number', i changed it to 'ShortText' and viola : )