L
lee
hi all,
does anyone know how to do the following in Access Charts.
i have a table with the following fields
Request_ID (PK) Date_Submitted (date) Date_Required (txt)
F_Notified (date) F_Returned (date) Sponsor_Notified (date)
(and others but these are the relevant ones)
i have been asked to create a chart that will display the
relationships between the above date fields.
Date_Required is either filled with "ASAP" or a given
date, if it is "ASAP" it will be no more than 5 days after
the Date_Submitted field.
i need a chart calculated on the following:
How many records = F_Notified more than & within 1 day
after Date_Submitted.
how many records = F_Returned more than & within 7 days
after F_Notified
how many records = Sponsor_Notified more than & within 1
day after F_Returned.
these can be in seperate charts if need be, i just need
some guidance on how to set up the queries that build the
chart.
i am fully conversant with VBA/SQL strings, so any help in
any form is appreciated.
many thanks all.
lee.
does anyone know how to do the following in Access Charts.
i have a table with the following fields
Request_ID (PK) Date_Submitted (date) Date_Required (txt)
F_Notified (date) F_Returned (date) Sponsor_Notified (date)
(and others but these are the relevant ones)
i have been asked to create a chart that will display the
relationships between the above date fields.
Date_Required is either filled with "ASAP" or a given
date, if it is "ASAP" it will be no more than 5 days after
the Date_Submitted field.
i need a chart calculated on the following:
How many records = F_Notified more than & within 1 day
after Date_Submitted.
how many records = F_Returned more than & within 7 days
after F_Notified
how many records = Sponsor_Notified more than & within 1
day after F_Returned.
these can be in seperate charts if need be, i just need
some guidance on how to set up the queries that build the
chart.
i am fully conversant with VBA/SQL strings, so any help in
any form is appreciated.
many thanks all.
lee.