Problem with make table query

[rowk]

Hi

i'm trying to run a make table query - when i run it as a select query it returns all the data - however when i run it as a make table query it gives the error invalid argument. I ran the same query in SQL: and basically got the same error. Any ideas??

Thanks

Row

 

[Russell Hauf]

Can you post your SQL?

 

[rowk]

Here's the SQL,

thanks

rowk

SELECT SERIALNUM AS Expr1, MAX(INVNUMBER) AS Expr2, MAX(ITEM) AS Expr3, MAX(CUSTOMER) AS Expr4, MAX(BILNAME) AS Expr5, MAX(CODETERR)
AS Expr6, MAX(INVDATE) AS Expr7, MAX(CATEGORY) AS Expr8
INTO SerialsFinalPCards
FROM Serials_PCARDS
GROUP BY SERIALNUM

 

[Bariloche]

rowk,

What is the Max() function supposed to do in this instance? I don't understand what Max(Customer) does, for example.

Also, what are the data types of the fields (just for curiousity's sake).

thanks

 

[rowk]

hi there,

the problem with the master table is that some records have been duplicated but have different customer numbers...so basically what i wanted to do was to group the results by serial number and then allocate the max (last) customer number etc.
does that make sense?

 

[Russell Hauf]

Hmm...

Not sure what's happening there. Do you think you could post some of your data? Click on the link below to download an add-in that will help you do this. Also, if you could base this on a query that is a simple select query of your table, but sorts the ID field (the one you are grouping on), that would be great. Maybe 25 rows? If the table is already sorted, then just post data from the table.

If you don't care to post the data from the add-in, you can try another way (or you can not post at all! ).

Click Here
This message was edited by Russell Hauf on 2003-01-17 12:14