User Profile

Collapse

Profile Sidebar

Collapse
nawara
nawara
Last Activity: Aug 4 '08, 02:44 PM
Joined: Jul 21 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nawara
    replied to Control source
    in Access
    hey thnks for ur reply.. is it posible u cud send me a data base sample bcz i honestly didnt get wat u werr saying lol
    sorry am fairly new to access please be patient with me
    regards Noor
    See more | Go to post

      Leave a comment:

    • nawara
      started a topic Control source
      in Access

      Control source

      hey i am having difficulties
      basically i have 4 frilds named:
      1)sub total-( this is the total not including the vat)
      2) VAT-( this is wther the vat is 0.00 or 0.175) 0.175 being the vat rate we use in the UK.. for this feild i created a drop down list which consisters of :
      0.00
      0.175
      3) VAT (T1)- Vat (t1) is the sum of sub total * VAT
      4) Total including VAT- (this is the sum of sub total + VAT(T1)...
      See more | Go to post
      • nawara
        replied to access how do i create a formula?
        in Access
        right i see..
        and were would i do these sums exactaly?
        sorry if am buggin you with a million questions
        though i really appreciate your replies...
        See more | Go to post

          Leave a comment:

        • nawara
          replied to access how do i create a formula?
          in Access
          ryt am stuck again
          ufffffffff!
          right wen i am writing 17.5% and tabbing onto the next colum which is VatAmount... its not calculating it:S:S:S:S:S
          does this site have an instant messanger i need 24 hour support due to my stupidity?
          lol
          thanks
          See more | Go to post

            Leave a comment:

          • nawara
            replied to access how do i create a formula?
            in Access
            :O:O:O bloody hell am so thick!!!!
            is that all it was
            seriously thank you soo much
            :):) you r soo sweet
            [flower for u]...
            See more | Go to post

              Leave a comment:

            • nawara
              replied to access how do i create a formula?
              in Access
              Hi H,
              why thank you very much for ur reply H,
              ok if i was to create a query then wat would i need to write in the criteria?
              i am assuming along the lines of sumthing like this =[sub total]*[100]/[17.5]?
              and also if i was to write that formula... would it automatically work it out for me everytime i enter a new supplier?...
              See more | Go to post

                Leave a comment:

              • nawara
                started a topic access how do i create a formula?
                in Access

                access how do i create a formula?

                hey everyone..thank for making such a helpful site

                i am going to tell you the backround and then proceed in telling you my problem

                i studied access about 2 years ago so.. my knowledge is a little limited

                ok basically i have created a table for the suppliers which we use in our company...
                one of my columns is called Sub Total , the following column is called VAT and thus Amount Including VAT...
                See more | Go to post
                No activity results to display
                Show More
                Working...