J
Jose Lopes
My company builds custom designed products different from customer to
customer. Each order may refer to only one reference or several references
from a customer. I’ve got a table of ORDERS where I keep a record of the
Order, PK number type, manual input. This table is linked by this Order field
to a second table of REFERENCES where the Reference is PK, string type,
manual input. This reference table has a delivery date field. Now, I’m trying
to achieve some kind of a visual chart (just like a MS Project Gant chart) to
help us recognise the days booked with a delivery. I recon that to integrate
a MS Project object or a MPP file to work in conjunction with my DB is
somewhere between impossible and hopeless (at least for me). So, I thought of
a simple Dynamic chart, but for that (and I don’t know if this is possible) I
need a query to generate a table with all the days not booked. I already have
a chart listing all the dates bigger than Now( ) found on the references
table but that does not help us visually see how many days are left to a
delivery. I could do it in Excell... with a little effort... but is this
possible in Access? Someone has any ideas on how to achieve a solution for my
case?
Thx all.
customer. Each order may refer to only one reference or several references
from a customer. I’ve got a table of ORDERS where I keep a record of the
Order, PK number type, manual input. This table is linked by this Order field
to a second table of REFERENCES where the Reference is PK, string type,
manual input. This reference table has a delivery date field. Now, I’m trying
to achieve some kind of a visual chart (just like a MS Project Gant chart) to
help us recognise the days booked with a delivery. I recon that to integrate
a MS Project object or a MPP file to work in conjunction with my DB is
somewhere between impossible and hopeless (at least for me). So, I thought of
a simple Dynamic chart, but for that (and I don’t know if this is possible) I
need a query to generate a table with all the days not booked. I already have
a chart listing all the dates bigger than Now( ) found on the references
table but that does not help us visually see how many days are left to a
delivery. I could do it in Excell... with a little effort... but is this
possible in Access? Someone has any ideas on how to achieve a solution for my
case?
Thx all.