Thanks for your help
however that’s does not work as I don’t know the date (which is 30/11/2005).
you SQL code will need user input for the date as I understand it
and the user does not know the dates!! (30/11/2005) is base on query1 output and query2 should automatically get that date(s) and do the required processing to show the past & next 5 days.
any suggestions!!!
Many thanks
Triple7
Last Activity: Jan 5 '07, 03:14 PM
Joined: Jan 4 '07
Location:
-
Thanks again for your help
The purpose of the first query is to retrieve the dates of the user input value
and the 2nd query is to get these dates and retrieve the past & next 5days against each day, for example
Query1
user input 202
Query1 Output
Date DLA
30/11/2005 202
01/04/2006 202
28/06/2006...Leave a comment:
-
Thanks for your reply,
your two lines of code make a lot sense and even a newbie like me can fully understand the logic behind it, however as I stated I really don’t know where to go to write that SQL statement!! (I guess I have a lot to learn)
anyway does that mean that the standard Query in access does not support such link between two queries. foe example query2 can never trigger query1 and retrieve the required...Leave a comment:
-
How to fill/link a query criteria based on another query result???
Hi there,
basically what I am trying to do (without using code as I don’t know how to do that with a code) is to retrieve the previous 5 days & the next 5 days (date wise)against a query1 that come up with a date against a user input value?
Query1
user input = 202
result one or more dates where "202" is associated with
query2
use each of query1 dates and retrieve values...
No activity results to display
Leave a comment: