query based on a field

[aymanmb]

I have a table that contains a field for order number of weeks prepared.

I have a query that I want to specify to list all clients based on that number of weeks.

The query should list client orders to be done today according to following formula

today's date - (number of weeks - 3 days)



how can I type above in the query criteria.

Thanks

[lfpm062010]

Can you clarify more on your formula?

For example: Today is December 13, 2013 Friday

Dec 13, 2013 - (??Number of weeks?? - ?? 3 days ??)

How do you determined Number of weeks? (table that contains a field for order number of weeks prepared)

How do you get the 3 days from?

[aymanmb]

Hi lfpm062010,

the number of weeks is a field in a table (changes for each order), so it has to be referred to in the formua, but do not know how. as for the 3, it is just number of days I give for myself ahead of next due day to prepare next order.

I hope this clarify your question.

Thanks

[lfpm062010]

Without knowing the table sturcture.

TableName: have [number of weeks] and [the days to be subtracted]

Now() - ([TableName].[number of weeks] - [TableName].)[the days to be subtracted])