Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. m4dd0g

    Need Help in vb and access

    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"...
  2. m4dd0g

    excell and vb

    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.
  3. m4dd0g

    Add duplicate entries together

    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
  4. m4dd0g

    Working With Two Tables

    Thanx For all your help and i learned alot from you guys I will recomend this site to all my programming friends You guys ROCK BIG TIME and i specially want to thank mirtheil for all the help and we will talk again of not in this life time then in the after life Enjoy the rest of the night or...
  5. m4dd0g

    Working With Two Tables

    OK when I export I gives me Only three Fields which is number,name and the date from the HistoryLines table nothing from the customermaster table
  6. m4dd0g

    Working With Two Tables

    OK so my line of code is right and Date is only in the historylines table but there where is specified the CustomerMaster.Number and The CustomerMaster.Description that data comes from the historylines table and not from the customermaster table like i specified
  7. m4dd0g

    Working With Two Tables

    I modified it like this but it only gives me the data from one table: mysql = "Select CustomerMaster.Number,CustomerMaster.Description,Date from CustomerMaster,HistoryLines where " & Chr$(34) & "Date" & Chr$(34) & " Between '" + txtFrom(0).Text + "' And '" + txtTo(0).Text + "' And...
  8. m4dd0g

    Working With Two Tables

    OK I could do that but then I loose my date query because i need that line of code you gave me to be altered in away so that it pulls that data out between two dates and two tables.
  9. m4dd0g

    Working With Two Tables

    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...
  10. m4dd0g

    Invalid Date,Time Or Timestamp

    Ok I understand but what if you want to compare two of the fields and if the data is the same export that data to excel because both of my tables have a customernumber field and when i export the data it puts the customer name and product name out but the customer name have the same product name.
  11. m4dd0g

    Invalid Date,Time Or Timestamp

    Thanx mirtheil your the man and then just one other thing if i want to import two tables of data but both tables have a field with the same name how do i go to work then because the guy that i'm doing this program for just told me that he wants both tables on one excel sheet.
  12. m4dd0g

    Help With ODBC

    Ok I think I fixed my problem but when I run my program and enter the two dates there is no data being imported to excel. this is how my line of code looks now and sql execute this with no problem and in my PCC it also display no data mysql = "Select...
  13. m4dd0g

    Invalid Date,Time Or Timestamp

    I think i fixed it can you just check this line because it works but it returns no data to excel: mysql = "Select CustomerCode,DocumentNumber,InclusivePrice,Qty,Description from HistoryLines Where '" & Chr$(34) & "[Date]" & Chr$(34) & "' Between '" + txtFrom.Text + "' And '" + txtTo.Text + "'
  14. m4dd0g

    Help with VBA

    OK that looks confusing and can i use that as a macro
  15. m4dd0g

    Invalid Date,Time Or Timestamp

    OK it seems to work but it gives me a syntex error that said something about between<<??>>2004-8-1.
  16. m4dd0g

    Help with VBA

    OK i understand how it uses the dates but i want to design a macro that would ask you to enter two different dates and then display the data which is in the range of that two dates and i want to do it with a macro because a macro starts up every time you run that excel sheet because that sheet...
  17. m4dd0g

    Invalid Date,Time Or Timestamp

    That date don't work and when i put the date in double quotes vb tells me expected end of statement.
  18. m4dd0g

    Invalid Date,Time Or Timestamp

    Ok I've tried all the ways you can enter a date and it still tels me Invalid date,time or timestamp and I've tried them like this 01/12/2004 to 31/12/2004 and like 12/01/2004 to 12/31/2004 and like this 2004/12/01 to 2004/12/01 and the other way around.
  19. m4dd0g

    Help with VBA

    ok got that query thing right but it nothing from my other excel sheet don't now why but its got the headers but no data.
  20. m4dd0g

    Help with VBA

    OK and how do i do that because i can only insert one criteria column with my query wizard

Part and Inventory Search

Back
Top