MS query just show one record

[herts2201]

Thank you very much JHB.
I was on busy in other works and could not finish this.
It works perfectly when I run standalone. but when I run with another query that get barcodes from the table in UNION query it through table mismatch error.
here is the sql from the query i want to make union

SELECT PRODUCTS.*
FROM SCANBARCODES, PRODUCTS
WHERE (((SCANBARCODES.barcodes)=[PRODUCTS].[BARCODE]));

If you can please help me to sort this out.

Thanks

 

[JHB]

Could you post some sample data from the involved tables + the queries you use.

 

[herts2201]

Thanks for the reply. I have attached the sample database


View attachment mydatabase.accdb

 

[herts2201]

Hi JHB sorry for troubling you again
I am also failed to copy the records of QRY PRODUCTS(query) in to ORDERS table. at the moment I copy and paste manually. I tried some sql statement and it does not work.

Thanks for your help

 

[JHB]

To help you I need the file "Barcodes.CSV".

 

[herts2201]

Hi. Thanks
Please find enclosed barcodes.csv

Many Thanks for your help

View attachment BARCODES.zip

 

[JHB]

Sorry but your zipped file isn't valid, (unable to open it).

 

[herts2201]

Sorry JHB. It does not allow me to attach .csv file that's why I zipped it. It is just a normal CSV(made in excel)file with one column.
Thanks

 

[herts2201]

Hi.
Thanks JHB

It allowed me to send in xls but not in csv.

View attachment BARCODES.xls

Regards

 

[JHB]

I think your problem is the Barcodes.CSV file.
The scanned number is to big for a long integer,
Long integer is in the interval:
−2,147,483,648 to +2,147,483,647
but your scanned number is
5.413.149.941.816
so it is far to big.
When you link the table, the field type for the barcode number must be text.
Ps: When you attached files click the "Manage Attachments" button or use the "Clips".