[MS_AccessPros] Query result as criteria for another query

 

Pros,

 

Can a query use another query as criteria for one field? Here is the SQL of my query:

SELECT tblWeeks.YearID, tblWeeks.WeekID, tblCity.CITYInitial, tblCity.CITYNAME, tblWeeks.ID
FROM tblCity, tblWeeks
WHERE (((tblWeeks.ID)>=[qryWeeksStartDate].[ID]))
ORDER BY tblWeeks.YearID, tblWeeks.WeekID, tblCity.CITYNAME;

 

The query prompts me for a value for [qryWeeksStartDate].[ID] which I used the query builder to make. I've also tried using Queries![qryWeeksStartDate].[ID] but I still get the prompt. When I run the query qryWeeksStartDate, I get the result I want. Here is the SQL of qryWeeksStartDate:

SELECT tblWeeks.ID
FROM tblWeeks
WHERE (((tblWeeks.WeekID)=DatePart("ww",[Forms]![frmWeeklyDeliveryReport]![StartDate])) AND ((tblWeeks.YearID)=DatePart("yyyy",[Forms]![frmWeeklyDeliveryReport]![StartDate])));

How can I get this query to run without the prompt?

 

Doyce

 

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___