M
Mike_can
Hi everyone.
i recorded a macro using the query databse. I was able to get the info from
the access query. But as i will need this information weekly i would have to
change the dates of the macro every time. Is there a way to enter the
starting and ending dates in 2 cells, and have the macro takeing this dates
as the parameter to get the data?
Here is part of the macro that i wrote (i think it's the part where the
dates are defined). How do i have to change it?
"General QGeneral" & Chr(13) & "" & Chr(10) & "WHERE (QGeneral.Date>={ts
'2004-08-16 00:00:00'} And QGeneral.Date<={ts '2004-09-22 00:00:00'})" &
Chr(13) & "" & Chr(10) & "ORDER BY QGeneral.Date" _
)
thnaks a lot!!!
i recorded a macro using the query databse. I was able to get the info from
the access query. But as i will need this information weekly i would have to
change the dates of the macro every time. Is there a way to enter the
starting and ending dates in 2 cells, and have the macro takeing this dates
as the parameter to get the data?
Here is part of the macro that i wrote (i think it's the part where the
dates are defined). How do i have to change it?
"General QGeneral" & Chr(13) & "" & Chr(10) & "WHERE (QGeneral.Date>={ts
'2004-08-16 00:00:00'} And QGeneral.Date<={ts '2004-09-22 00:00:00'})" &
Chr(13) & "" & Chr(10) & "ORDER BY QGeneral.Date" _
)
thnaks a lot!!!