Can I use one prompted date critera to create others?
Hey,
I have had to set up several rather complex queries using nested queries. I am required to enter an initial date, and would like to be able to use that one entry to query the next level of query for a date exactly one month later than the first, and in another case, to have the next level query look back exactly 365 days from the date I originally entered, and in another case merely pass through the original date into another query that is relationally connected to the daughter query of the one where I input the original date.
I tried ([StartDate] - 365), but it didn't like that.
I can manipulate dates in calculated fields rather easilly, but apparently none of this works in the criteria box. So, I currently have several prompts to manually type dates into. This is a major opportunity for errors.
If anybody has any ideas, or a suggestion on a place to look, please let me know.
Thanks,
Lee
|