Search results

Ignore the excel. I just had that in there for examples of due dates. That is all.

I am performing a DateAddW function. Due Date: IIf([Account]=PSG, DateAddW('d','5',[ReceivedDate]) So all accounts = PSG. I want to add 5 work days to the received date and deliver on the 6th day. Problem is with Saturdays and Sundays. Example: Sunday 4/5/2009, the actual due date is...

DateAdd Functions I am trying to perform some date due functions, however have an issue with it. I am performing a DateAddW expression, however...I need to account for Sunday's and Saturdays. See table below. TAT Schedule Examples attached.

Can you elborate on this? NZ function... This is what I have built: DeliveryDueDate: DateAdd("h",[TurnaroundTime],[ReceivedDate]

Trying to do a dateadd in hours in access and if one of the fields that needs to be populated to calculate this field is not populated I get an #Error message. How can I just show this as blank?

Tried that...but have a record that is showing no and dates and times are... Delivery Date = 2/3/2009 7:10:00 AM Due Date = 2/3/2009 4:30:00 PM however shows yes if on a different date, or is actually late. Thoughts

Trying to do a date calculation. I have two dates, Delivery Date and Due Date. I want to show whether it is ontime. Date format is MM/DD/YY 6:34PM for both. I wrote this statement: IIf([Due Date]<=[Delivery Date],'No',IIf([Due Date]>[Delivery Date],'Yes')) This works, however if the due...

I'm not, I can use either military time or short time. Either will surfice.

I have a received time... 1/31/2009 14:00:00 PM I need to default this time to a standard. So if the time is on or before 16:00 PM it defaults this time to '1/31/2009 4:00:00PM' and if it is greater than 16:00 (i.e.1/31/2009 18:30:00 PM) it defaults back to 16:00 PM. Please help!

I am doing a simple query, however need to know how to do a date calculation. I have a product received time. I need to run a query that notifies me if it has not been confirmed onboard flight within 24 hours from that received date. How do I do this.

It's not...it is set to the first field under the tabs. It is about an inch down on the screen. Thanks for the thought. Any other ideas?

I have a form that I pull up in my database. When the form shows up, the side bar shows half way down the screen. How do I fix? I have tabs at the top of the form and they need to be seen.

Awesome...that worked great. Thanks Shannon

No, sorry to be so difficult. I have many fields, here is a sample of the data. 1. BND, GAD, AD, AD 2. BND, GAD 3. AD, HO 4. Null For example, I just want to see the last record on this dataset. Strip the front characters. 1. AD 2. GAD 3. HO 4. Null

This did not help... I have potentially 3 sets of characters in a field and could be more. i.e. Delay Code Variations that could happen DLY, BND, AD BND, AD AD Null I need to only pull AD and leave the rest out. Could be sometimes one delay code, or could be up to 5. Thoughts?

I have a query that has multiple values in a row. i.e. Delay Codes qryTotalDaysTransitDLYBND, GAD, AD I only want to show AD, and remove the remaining leading characters. The field could also be null. Any advice?:D

I used both 'd', and 'w' and they came back the same. So if I have a day (1) Sunday and I want to return (5) workdays (business days) then I would do a DateAdd("w", 5, Date()). Please help! Shannon

Please help...new to access. However I understand the function at hand,but cannot get it to work. I need to add working days between these dates. So I used the 'w' function in the below statement, however it is working the same as 'd'. HELP!! Here is my function below: EDL HP PO Due...

New to access, so please bare with me. I have a table that is the host for all my master data. I have a field in the table that does not except duplicates. It is the HouseAirwayBill. Every day I get a file from another source and I import it into my database, however since my...

I am still getting this #Error. The field of sample data is: DLY (Header Field) Data below. DM DM, ECL, GAD, GSH, HAO, HED HAO, HED I need to pull only the first one, to pull the new: DLY (Header Field) Data below. DM DM HAO