Results 1 to 6 of 6
  1. #1
    smaky is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    3

    InputMask yyyy-mm for Label


    Hi,
    I have a query with 12 fields for some demand (number)
    ex:
    Field name: 2010-01 2010-02 2010-03 ...
    Demand (Data): 5 78 0

    Is it possible to create an inputmask for the label because when I'm running my Qry, the field name become 2010-1, 2010-2 ...
    I'm missing the 0.
    I MUST have this format yyyy-mm
    Because of that, all my other qrys are wrong!
    Can you help me please.
    Thanks!

  2. #2
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi Smaky,

    as an input mask is used when entering data into a field, you can't obviously use this for a label. What you can do is: or use the caption property of the field to alter the title,or just add the correct title as if you had a calculated field:
    select 2010-1 as 2010-01, .....
    I must add that I'm not so happy with field names as "2010-01". I suspect, however, this could be the result of a cross-tab query??? In this case you have to look at the data that make up the title...

    gr
    NG

  3. #3
    smaky is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    3
    Hello,
    No it's not a cross-tab Query. I tried to change the caption but it's only the visual aspect that changed not the label's value.
    Do you have more idea?
    Thanks

  4. #4
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,

    change the field names in proper structured names, and then change the queries based on these field names??

    grNG

  5. #5
    smaky is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    3
    no it's not a good idea! I need something faster!
    My database contains more than 200 Qrys !!!!

  6. #6
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Then try to alias the fields, as I stated as a second option in my first answer.

    grNG

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

Similar Threads

  1. Replies: 2
    Last Post: 08-17-2010, 01:10 PM
  2. label error
    By RedGoneWILD in forum Access
    Replies: 2
    Last Post: 08-04-2010, 07:19 AM
  3. Convert to MMM/YYYY
    By Brian62 in forum Queries
    Replies: 10
    Last Post: 08-31-2009, 04:54 PM
  4. Replies: 1
    Last Post: 06-11-2009, 05:40 PM
  5. A Label in a Switchboard
    By Hawkx1 in forum Forms
    Replies: 1
    Last Post: 07-09-2008, 12:37 PM

Tags for this Thread

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