Calculations and queries

[CFP - Jason]

i have a date that is calculated from another date from the frequency. Thats value is not stored its calculated everytime. Now i need to run a query to find the events that fall in a range that would be covered in the calculated date. should i store that date, if so how do u store the calculated values. and if not, how do u get a query to search a calculated field with a date range criteria. I am soo lost here.
Thanks in advance for the guidance.
Jason

 

[WayneRyan]

Jason,

I don't know your app, but are you aware that you can use
a query as the basis for another, etc.

If your first query, retrieves a date and some values, then
a later query can join that query with a table and produce
results.

Just a concept,
Wayne

 

[CFP - Jason]

how would i use calculations in queries, i thought only reports and forms could do that.
my dilema is that is that i need a query to list what events fall in a certain time frame, i know how to do it with a stored value(date manip etc) but i dont know how to run a date comparison on something that i cannot even see in the query. the frequency is a variable in a combo box that recalcs the value. if i can either store it or figure out how to see it in a query i would be fine.
Jason

 

[WayneRyan]

Jason,

Your requirements are too vague. Could you elaborate further
and post a compacted/zipped db?

Wayne

 

[CFP - Jason]

i got it figured out, but thanks tho.
Jason