473,320 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to add both records value against same name in database?

I have one database in which two columns 1 is for supplier and another for amount for material.
here, same supplier have different amount for different material.I want add that both the amount of same supplier instede of both different records in amount column.Plz guide me..
Jul 22 '12 #1
2 1798
I have one database in which two columns 1 is for supplier and another for amount for material.
here, same supplier have different amount for different material.I want add that both the amount of same supplier instede of both different records in amount column.Plz guide me..
Jul 22 '12 #2
lyodmichael
75 64KB
did you try this? http://bytes.com/topic/access/insigh...ble-structures

if you do just create the right query .

#tip
Jul 22 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Jack | last post by:
Hi, I have a checkbox the value which goes to a database via a asp page that builds the sql string. In the front end asp page, the checkbox code is written as follows: <i><input...
1
by: Ramesh | last post by:
hi, I am selecting fields from three table for manupulating data and i want to display total number of records selected. But i am always getting -1 value, eventhough 1000 of records are selected....
2
by: Salih Ataoz | last post by:
at vb6 there is recordcount property ex: msgbox rst.recordcount at .net i dont know how to learn how many records i have in database is there any property to learn it
7
by: lawrence k | last post by:
Okay, I just backed up my database, just in case. The whole schema for the database is here: http://www.accumulist.com/index.php?whatPage=db.php You can run any SELECT query against this...
3
by: redhat | last post by:
I'm stuck trying to compare date values from users selection against a database which is Access. This is my problem I get two date from client with mm/dd/yyyy format transfer via form to my asp...
2
by: peterhinett | last post by:
Hi. iv been able to create a loin form bu I am stuck on the code. what i want is for a manager to be able to enter his manager ID and password and it to be checked against a database. I have set up...
17
by: anojjona | last post by:
Hi, I need to figure out what some code that was maliciously executed against a database does. However, it's in a very strange format. It simply declares a variable and sets it equal to a huge...
4
by: jehugaleahsa | last post by:
Hello: What is the best way to test my methods that hit a database? I believe tests should be as automated as possible. However, I'm not sure how I can test against a database since changes...
8
by: chandhseke | last post by:
Hi Team, I have designed a dynamic form with number of elements, i am stuck with a requirement where i need your help. The requirement is : While a user fills out the form, one particular text...
2
by: qwedster | last post by:
Folk! How to programattically check if null value exists in database table (using stored procedure)? I know it's possble in the Query Analyzer (see last SQL query batch statements)? But how...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.