User Profile

Collapse

Profile Sidebar

Collapse
helpless
helpless
Last Activity: Nov 21 '06, 01:48 PM
Joined: Nov 16 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • helpless
    replied to Copying a field to multiple fields
    in Access
    Thanks, I read that and realized I guess I wasn't specific.

    I am using a table only, not a form, it seems like that language is referring to a form with a toggle button.

    thanks, helpless
    See more | Go to post

      Leave a comment:

    • helpless
      replied to Calculate the difference between two dates
      in Access
      Hi,

      Thanks, I tried that, but then it gives me an invalid syntax error.

      that's ok, I think I'll keep putting in the dates manually!

      thanks
      See more | Go to post

        Leave a comment:

      • helpless
        replied to Calculate the difference between two dates
        in Access
        Hi, see I really am helpless!!

        I put this validation rule into the Age field:

        =DateDiff("yyyy ",#5/1/2007#,[Birth Date])

        and I am still getting the same error. It looks like it thinks 5/1/2007 is a column/field, but it is not.

        thanks anyway!
        See more | Go to post

          Leave a comment:

        • helpless
          replied to Calculate the difference between two dates
          in Access
          Hi,

          I am trying diligently and getting this error:

          Invalid Syntax error - cannot use multiple columns in a column-level CHECK constraint.

          this is what I did: in the Validation Rule for Field name Age

          =DateDiff("yyyy ",(5012007) ,[Birth Date])

          5/1/2007 is just the date I am comparing the birth dates to. It is nowhere else in the db.....can you help?
          See more | Go to post

            Leave a comment:

          • helpless
            replied to Copying a field to multiple fields
            in Access
            Thanks for your response. I have never been able to figure out how to do this, I think because if will only copy and then paste to the same exact number of fields. I do this alot in dbs where I have people who meet the same criteria for something, e.g. state, so It would be nice to be able to copy and paste it for all rather than for each one.

            thanks again
            See more | Go to post

              Leave a comment:

            • helpless
              started a topic Calculate the difference between two dates
              in Access

              Calculate the difference between two dates

              Access 2003 - I am trying to calculate the difference between a specific date 5/1/2007 (not in a data field) and other dates that ARE in a field called Birth Date. I am trying to have it fill into an Age field (in years only) by comparing the date above to the Birth Date field. I have tried this and it doesn't work:

              =DateDiff("yyyy ", [Birthday1], [Birthday2]) Displays the variance in years between the values of the Birthday1...
              See more | Go to post
              • helpless
                started a topic Copying a field to multiple fields
                in Access

                Copying a field to multiple fields

                Access 2003 - Is there any way to copy/drag data from one field to multiple fields in the same column?
                See more | Go to post
                No activity results to display
                Show More
                Working...