query which looks at date/time format but needs calculation in days

[WillJulian]

<br><br>so my problem is I need to find the leadtime of a part and also the production start date.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fields=<br><br>1.DUEDate-(ProductionTime+VendorLeadTime)=LeadTime<br>2.DUEDate-ProductionTime=production start date<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Format= <br>1.dd/mm/yr-(days+days)=days<br>2.dd/mm/yr-days=dd/mm/yr<br><br>Is this possible and how do I go about creating the query?<br>A friend mentioned something about Julian-dates but I haven't found any mention of this in Access.<br>Thanks<br>Will

 

[famousb]

ok, quick question. wouldn't your Lead Time in days just be your ProductionTime+VendorLeadTime?&nbsp;&nbsp;The DUEDate has no use in hear if you just need a number of days it takes to do the order. If you want to know when to send the order to the vendor, then you would need a date.&nbsp;&nbsp;but here are the basic formulas (just doing a total of days, without regard to DUEDate on the first one):<br><br>1. <b>LeadTime: [ProductionTime]+[VendorLeadTime]</b><br>2. <b>ProductionStartDate: [DueDate]-[ProductionTime]</b><br><br>just create a query with the fields ProductionTime, VendorLeadTime, and DueDate included in it, and then in the next two blank columns paste the bold lines.<br>you can also format the properties of the DUEDate field to a ShortDate format, and include the Input mask so you don't have to type the &quot;/&quot;, if you didn't already do that in your table.<br> <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>