I have hardly ever used access, and i missed the class that they taught me access, and now i need a list of reserved words in access.
Also, is it possible to do such a statement:
SELECT *
FROM Product
WHERE [Product].[Manufacturer]={some kind of variable}
{if variable is NOKIA, SONY ERICSSON, MOTOROLA, SAMSUNG, or SIEMENS,
then show only that model
else show all}
edit: here is a picture of the situation, if it makes it any easier to understand :
Also, is it possible to do such a statement:
SELECT *
FROM Product
WHERE [Product].[Manufacturer]={some kind of variable}
{if variable is NOKIA, SONY ERICSSON, MOTOROLA, SAMSUNG, or SIEMENS,
then show only that model
else show all}
edit: here is a picture of the situation, if it makes it any easier to understand :