Results 1 to 3 of 3
  1. #1
    aftfm is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2014
    Posts
    22

    How do I change my Mark in this code through the Computer History

    Hi


    I have a query from a tabular type and you where to look through history shows the beginning of the month comes to an end
    And you add the year as through this code (Year([Msg_Date])=2014)


    How do I change my Mark in this code through the Computer HistoryClick image for larger version. 

Name:	MonthAndYears2.png 
Views:	9 
Size:	33.0 KB 
ID:	18970

    Click image for larger version. 

Name:	MonthAndYears1.png 
Views:	9 
Size:	13.9 KB 
ID:	18971

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Not sure what you mean by change the mark. If you want to enter the year, the simplest is to replace the year with bracketed text like:

    [Enter year]
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    aftfm is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2014
    Posts
    22
    Thank you for answer


    He found the solution in the picture
    Now Ward showed that the days of 1 to 31 in the headlines no matter how many days of the month whether there is data in this Alioune or not
    Click image for larger version. 

Name:	Query1.png 
Views:	7 
Size:	20.8 KB 
ID:	18972

    Because they appear only days that the data


    And I want to show a full-day month and normalize specifically from 1 to 31, whatever the number of days of the month
    Click image for larger version. 

Name:	Query2.png 
Views:	6 
Size:	7.5 KB 
ID:	18973

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

Similar Threads

  1. Replies: 2
    Last Post: 07-22-2014, 09:30 AM
  2. Replies: 4
    Last Post: 11-29-2012, 12:45 AM
  3. Replies: 4
    Last Post: 09-18-2012, 08:49 AM
  4. Replies: 1
    Last Post: 05-25-2012, 10:36 AM
  5. Computer locks on a code error
    By gg80 in forum Programming
    Replies: 6
    Last Post: 05-17-2011, 03:00 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
  •  
Other Forums: Microsoft Office Forums