Recent content by Mariners

DISTINCT Keyword The DISTINCT keyword did the trick! Thanks. Dave

Forgot an important detail Thanks for the help, the sql statement worked except I left out an important detail about Table A. It has duplicate ProductId records, there is a potential to have the same ProductId record many times in Table A. There is another field in Table A that called Period...

It was suggested to me to use a Not Exists Join to accomplish the below problem. I'm not sure how to write SQL for this. I have the following: 1,000 records in table A 500 records in table B Field ProductId is common to both tables. If a ProductId from table A does not exist in B table...

I didn't mean to infer the two formulas were equivalent, it was an example of one method working and the other method not working. A coworker found the solution on Microsoft web site, used Google to locate, the Microsoft site is difficult to locate information. There are several different...

I have a column formatted as a number, no decimals, with a ','. This data has been exported as Xls 8.0 Extended from a 3rd party application. I can manually enter a formula and I get correct results for =A2+A22, but when trying to use AutoSum it simply comes up =SUM() and not =SUM(A2:A22).

Access 97 SR1 I am importing a file that has two numeric fields in it. I was asked to import as fixed length text fields with leading zeroes and no decimal point. I am supposed to export the data in Csv format. Source field from IBM iSeries DB: quantity is 15,3. Quantity source value...