Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. antheana

    28 days from end of date

    I ended up finding another solution. On the form, I went with: AfterUpdate for the InvoiceDate field: [JobPaymentDate] = [JobInvoiceDate] + 35 - Weekday([JobInvoiceDate]) This actually takes it from the Saturday, which is a better solution as for some jobs, Saturday is still a working day...
  2. antheana

    28 days from end of date

    I tried that and it seemed to not show 2 of my jobs. I entered: (Int([JobInvoiceDate]/7)*7+6)+28 Under the Criteria section of the JopPaymentDate field that I'm trying to work out
  3. antheana

    28 days from end of date

    I SO don't have as much Access knowledge as I thought! Where would I need to enter that? I've tried to put it in the JobPaymentDate field and it didn't like it. Can I have the 'inserting code for dummies version?' please?
  4. antheana

    28 days from end of date

    Hi there, Thanks for your reply. I'm not sure if I know if there is a C6! I'm not using Excel, I'm using MS Access (have I posted in the wrong forum?) Will this still work? If so, do I still write it the same way?
  5. antheana

    28 days from end of date

    Hi there, I have a job table and am capturing the invoice date, payment terms (e.g. 28 days) and invoice due date. I have just found out that the payment terms are 28 days from the end of the week. I have: JobPaymentDate =[JobPayment]+28 How can I get it to identify which day of the week it...

Part and Inventory Search

Back
Top