User Profile

Collapse

Profile Sidebar

Collapse
mandy1
mandy1
Last Activity: Jun 27 '07, 07:08 AM
Joined: Jun 21 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mandy1
    started a topic ERD in Real World
    in Software Development

    ERD in Real World

    hi to all
    i know this is technical forums, but my need is bit different.
    plz if any can help me i will be very gratitude to all for this.

    Can any one give me some source where i can find database requirement to construct Complex ERD. by complex i mean real world examples.
    plz if any one know such case study/example, plz provide me address for this case study.


    Mandy
    See more | Go to post
    • mandy1
      replied to Function to Return Month from a Date
      in Access
      Hi
      thanks for replying.
      This is working well in Access.
      but again the same problem.
      not work through Excel to extract data from MS-Access.

      if u know any other function Plz send that one.

      once again Thanks
      With Regard
      Mandy(Mandee)...
      See more | Go to post

        Leave a comment:

      • mandy1
        replied to Set Validation Rule For Specific Characters
        in Access
        hi
        u can write follwing in the validation rule.

        Like "*-*"
        where fist * means any character can be placed before the - sign and second * means any character can be placed after the - sign.

        if u want to apply two conditions then u can use the following

        Like "*-*" OR "*#*"

        where # can be any special character that u want to use for your condition....
        See more | Go to post

          Leave a comment:

        • mandy1
          started a topic Function to Return Month from a Date
          in Access

          Function to Return Month from a Date

          Hi to all
          i am Mandeep new to all of You.

          i have a Problem and hope solution from you.

          i want to return only Month of the Given date. suppose i have a field order_date in the order table. i want display list as follows.

          Date_Result
          jul
          aug
          dec
          jan
          jan
          feb so on

          i am using following query.
          select =format(order_d ate,"mmm") AS...
          See more | Go to post
          • mandy1
            replied to how to ignore time and get only date in a query?
            in SQL Server
            Hello to every one. Myself Mandeep and new to all of u.

            u can use following format to extract date, or date+time
            suppose your date and time are stored in DTime field. then u can use following.

            Format(DTime, "General Date") Example date+time
            Format(DTime, "Long Date") Example sunday,december 02,2006
            Format(DTime, "Medium Date") Example same...
            See more | Go to post

              Leave a comment:

            • mandy1
              replied to Foreign Key
              in SQL Server
              Can u explain your problem a bit more. and can u provide some structure that u want to create.


              Mandy...
              See more | Go to post

                Leave a comment:

              • mandy1
                replied to Need some help with query
                in SQL Server
                Hi
                Different way for different queries exist.
                if u still have problem in 3rd query u can use the following.

                SELECT a.NAME
                FROM
                EMPLOYEE AS a, WORKSON AS b
                WHERE a.SSN=b.SSN and b.PNUMBER IN
                (SELECT PNUMBER
                FROM PROJECT
                WHERE PLOCATION NOT IN('HOUSTON'));

                IF U STILL HAVE ANY PROBLEM IN ANY OTHER QUERY PLZ TELL I WILL TRY MY BEST TO SOLVE THAT ONE....
                See more | Go to post

                  Leave a comment:

                No activity results to display
                Show More
                Working...