OK i've created my database and in my table called "Table1"
i've got the entries of all my data which i imported from and excel sheet but now i've got data entries with the same name like this 0000P,LP Gas,9,6.1,8.9 which i need all of those entries add up and put in a table called "Table2"...
What i've done so far is i export my data from an pervasive database to excell but now i need to caculate the sum of all the duplicate entries and export that to excel so that i will only give me the customer number the name and the sum of all the stuff he brought for the specific month.
Is there a way with a SQL query to add the duplicate entries in two tables together so that the entries that have more then one value only give me one value but all of them added together
Ok what I want to do is I want to export data from two tables into one excel sheet but the tables have the same name and what i want is to export the information from the tables where the customer number is the same it must put the number and name from one table and the cash data from the other...
OK i'm new to this VBA stuff so what i want to do is I got my excel workbook with data which was imported from a database and i want to create a form with two textboxes and a button which will search my workbook between to dates with i specify in the textboxes and then display that data on the...
This is the error i get when i search a pervasive database between to dates need help
Invalid Date,Time or Timestamp
And here is the code i Used:
Private Sub cmdSearch_Click()
Dim rsTemp
Dim lc
Dim k
Dim sRecords
'Connect To Database
Set objConn = CreateObject("ADODB.Connection")...
Well I need help with some code what I need Is to search a table by date by using two textboxes one for the start date and one for the end date here is the code that I have use so far:
Private Sub cmdExcel_Click()
'Excell Object
Dim rsTemp
Dim lc
Dim k
Dim sRecords
Set objConn =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.