Results 1 to 2 of 2
  1. 07-30-2016, 11:05 PM #1
    Khatuaaccess
    Khatuaaccess is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    Jul 2016
    Posts
    13

    display max date in form textbox, from table - access 2016


    i have a column for date of each rows.

    i want to show the max of date in form text box
    Reply With Quote Reply With Quote
  2. 07-31-2016, 03:13 AM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Take a look at DMax() function
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Details will not display in alphabetical order in 2016
    By Edward Austin in forum Reports
    Replies: 1
    Last Post: 04-27-2016, 08:00 PM
  2. Renaming Query and table in MS Access 2016
    By CHEECO in forum Access
    Replies: 3
    Last Post: 04-17-2016, 01:03 PM
  3. Dmax, Dmin in Unbound textbox forms based on Date criteria, Wrong number display?
    By radian89 in forum Access
    Replies: 12
    Last Post: 12-25-2015, 12:47 AM
  4. Making a Textbox display a value from a table when an items is selected
    By rajikasimu in forum Forms
    Replies: 1
    Last Post: 03-17-2015, 03:59 AM
  5. Textbox to display text for corresponding value in table
    By Deisun in forum Forms
    Replies: 3
    Last Post: 08-18-2011, 07:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums