Forum Discussion

Martín Mendorob9's avatar
Martín Mendorob9
Copper Contributor
Oct 11, 2017

Query to an external database

Help friends! i have created a query to an external data base with several parameters that i want to ba able to change them using excell cells. i managed to do so with 2 filters and it worked as you can see in image 1 (the filters) and image 2 (the result)

 

image 3 shows the next filter i want to add, and the original field is a character type, so i change as you can see on image 3, and shows an error (Image 4). i set the third parameter (serie) in the cell next to NRO FACTURA, wich in the image case its vlaue is O

 

how can i add that filter in the query?

 

my mail if you need more data

mendorob9@gmail.com

 

thanks!

 

 image 1Image 2

Image 3Image 4

No RepliesBe the first to reply

Resources