A LIST IN A QUERY
9 views
Skip to first unread message
Zizo Millicent Mambumba
Nov 9, 2020, 8:21:51 AM11/9/20
to
Hi All,
I am creating a database that has price list comparison from different stores.
I have a Stock Code query that contains a list of Stock Codes. I want to create a query that has a list of the STOCK CODES and PRICES from different stores.
I want is the Stock Code does not appear in a store records to display "not found" on the PRICES field, but if it does for it to show prices.
Regards,
I am creating a database that has price list comparison from different stores.
I have a Stock Code query that contains a list of Stock Codes. I want to create a query that has a list of the STOCK CODES and PRICES from different stores.
I want is the Stock Code does not appear in a store records to display "not found" on the PRICES field, but if it does for it to show prices.
Regards,
Ron Weiner
Nov 9, 2020, 8:05:53 PM11/9/20
to
Zizo Millicent Mambumba presented the following explanation :
How about providing us with the names of the table(s) with the column
names. Based on what you have described, the only advice I can give
you is to look at creating a Crosstab query.
If you provide the table and column names with examples of the data,
and a example of yopur desired result, someone awill take on the thask
of writing your query.
Ron W
--
This email has been checked for viruses by AVG.
https://www.avg.com
names. Based on what you have described, the only advice I can give
you is to look at creating a Crosstab query.
If you provide the table and column names with examples of the data,
and a example of yopur desired result, someone awill take on the thask
of writing your query.
Ron W
--
This email has been checked for viruses by AVG.
https://www.avg.com
Reply all
Reply to author
Forward
0 new messages