Page 1 of 3 123 LastLast
Results 1 to 12 of 27

Thread: Access Experts

  1. #1
    Omer27's Avatar
    Omer27 is offline Advance Member
    Last Online
    30th January 2024 @ 04:01 PM
    Join Date
    27 Jan 2009
    Age
    31
    Posts
    1,725
    Threads
    72
    Credits
    1,374
    Thanked
    66

    Default Access Experts

    mere paas ms access ka aik table hai.

    me chahta hon ke Net_Total wale column ki pehli row me Price ki value me se Discount ki value minus ho kar aaye jese (10-5).aur Net_Total ki 2nd row me Net_Total ki pehli row ki value (5) me 2nd row ki Price ki value (20) plus aur Discount ki value (10) minus ho kar aaye jese (5+20-10) aur isi tarah neche wali rows bi aaye.
    Mujhe koi query ya koi formula chahye jis se me ye kar sako.
    Attached Images Attached Images  

  2. #2
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 10:43 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    بھائی یہ تو ٹیبل ہے نہ۔۔۔آپ اس ٹیبل کو استعمال کہا ں کر رہے تو کوڈینگ تو وہاں استعمال ہوگی اس کے حساب سے

  3. #3
    Omer27's Avatar
    Omer27 is offline Advance Member
    Last Online
    30th January 2024 @ 04:01 PM
    Join Date
    27 Jan 2009
    Age
    31
    Posts
    1,725
    Threads
    72
    Credits
    1,374
    Thanked
    66

    Default

    is table me values mene manually enter ki hai.mujhe Net_Total wale coulumn me formula ya query chahye jis se ye result aaye.

  4. #4
    Omer27's Avatar
    Omer27 is offline Advance Member
    Last Online
    30th January 2024 @ 04:01 PM
    Join Date
    27 Jan 2009
    Age
    31
    Posts
    1,725
    Threads
    72
    Credits
    1,374
    Thanked
    66

    Default

    kisi ko nai pata?

  5. #5
    Join Date
    14 Mar 2009
    Location
    IN YOUR MIND
    Age
    35
    Gender
    Male
    Posts
    9,563
    Threads
    334
    Credits
    152
    Thanked
    1125

    Default

    ye easy hy bhai lekin lamba process hy or aapko samjhana b mushkil hoga.aap u kre s symbol say start kre =net total first row pr click kre pher minus lekho pher discount ki row pr click kre for eg =r1 -r2

  6. #6
    Omer27's Avatar
    Omer27 is offline Advance Member
    Last Online
    30th January 2024 @ 04:01 PM
    Join Date
    27 Jan 2009
    Age
    31
    Posts
    1,725
    Threads
    72
    Credits
    1,374
    Thanked
    66

    Default

    nai bhai is tarah nai ho ga

  7. #7
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 10:43 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    آپ نے جو ٹیبل بنایا ہے اس میں
    Price and Discount
    کی جو فیلڈ ہیں ان کو نیومیرک رکھا ہے پراپرٹی میں یا نہیں ۔۔اگر آپ کا جواب نہیں میں ہے تو ان کو نیومیرک کر لیں
    اگر نیومیرک ہےتو

  8. #8
    Omer27's Avatar
    Omer27 is offline Advance Member
    Last Online
    30th January 2024 @ 04:01 PM
    Join Date
    27 Jan 2009
    Age
    31
    Posts
    1,725
    Threads
    72
    Credits
    1,374
    Thanked
    66

    Default

    New merk ki samajh nai aayi.aisi tu koi property nai hai.

  9. #9
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 10:43 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    chose option from title bar ...CREATE...
    from right side ......QUERY DESIGN
    new window open ...close it
    and see your left hand side SQL now
    you can see a new tab...QUERY1
    here already as ....SELECT;

  10. #10
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 10:43 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    *, PRICE-DISCOUNT as (new field name) from (table name)

  11. #11
    Omer27's Avatar
    Omer27 is offline Advance Member
    Last Online
    30th January 2024 @ 04:01 PM
    Join Date
    27 Jan 2009
    Age
    31
    Posts
    1,725
    Threads
    72
    Credits
    1,374
    Thanked
    66

    Default

    Oper aap ne kya likha hai.mujhe kuch samajh nai aayi

  12. #12
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 10:43 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    میری مراد ہے ڈیٹا ٹائپ میں اس کی پروپرٹی نیومیرک رکھیے گا

Page 1 of 3 123 LastLast

Similar Threads

  1. ~* Wireless Internet Tips *~
    By shah2010 in forum General Discussion
    Replies: 27
    Last Post: 26th August 2016, 01:25 AM
  2. Expired Mobilink Free Internet Working With MMS (APN) 5/4/2012
    By Salmaaa in forum General Mobile Discussion
    Replies: 910
    Last Post: 10th April 2012, 11:50 AM
  3. VTC - Microsoft Access 2007
    By djhotmax in forum Courses
    Replies: 2
    Last Post: 6th January 2012, 12:22 PM
  4. Solved Windows XP restricted folder access
    By pretty_sana in forum Solved Problems (IT)
    Replies: 17
    Last Post: 30th December 2010, 07:58 PM
  5. Warid Access (wireless) Data Card
    By boblik in forum General Mobile Discussion
    Replies: 5
    Last Post: 29th January 2009, 08:59 PM

Bookmarks

Posting Permissions

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