Results 1 to 5 of 5
  1. #1
    Kirsten A is offline Novice
    Windows XP Access 2013 32bit
    Join Date
    Jul 2018
    Posts
    11

    Generating an expiry date from date + shelf life

    Hi, Very new to access. I’m trying to run a query that will give me an expiry date from a date + a shelf life. I have set up the query with column 1 = Arrival date, column 2 = shelf life and I’d like to have my column 3 show the expiry date?


    I’ve tried using the DateAdd function but it doesn’t seem to do what I want. There is probably a really simple way to do this! Any help greatly appreciated!

    Managed to work it out, was simple. Not sure how to delete this post?

  2. #2
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    thread tools > mark as solved should be enough.

    you don’t actually need this information in tables as tables are not intended for the user to see. If you have a lot of records and you perform a calculation on everyone it may slow down your DB.

    Instead you can perform the calculation on the relevant form or report.

  3. #3
    Kirsten A is offline Novice
    Windows XP Access 2013 32bit
    Join Date
    Jul 2018
    Posts
    11
    Hi, thanks I'm running a query so it will just be in that. Is that the correct thing to do? Very very new.

  4. #4
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    It is, and you did say, I should have read!

  5. #5
    Kirsten A is offline Novice
    Windows XP Access 2013 32bit
    Join Date
    Jul 2018
    Posts
    11
    No worries
    Cheers

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-30-2015, 12:19 PM
  2. query expiry to show just out of date
    By richard_rendle1972 in forum Queries
    Replies: 1
    Last Post: 03-16-2015, 02:55 PM
  3. Parameter coming up for expiry date
    By FranCorona in forum Queries
    Replies: 2
    Last Post: 08-09-2013, 09:59 AM
  4. expiry date query help
    By graemespence1 in forum Queries
    Replies: 3
    Last Post: 11-22-2011, 09:23 PM
  5. Calculating Expiry Date -
    By Jojojo in forum Programming
    Replies: 12
    Last Post: 10-05-2011, 12:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums