Logosmaid

[logosmaid]

Hi everyone,
I am a mom wife and grandmother who has gone back to school I am studying IT and at the present time am taking Access. I have some trouble with the signs (><'" []()and how to use them. But I am working on it any helps would be appreciated. I am not working at the present time due to the job market so I decided to go back to school to validate the things I learned on the job and to learn more new things. Hopefully a higher education will assist me with employment in the future.

Thanks,
BJC

 

[Martins]

Hi there- congratulations and good luck on your educational ventures!

Some things to remember:

Comparison Operators such as <> (not equal to), > (greater than), < (less than), >= (greater than or equal to), etc. are normally used for comparisons between numbers and/or dates (in some cases they can also be used on text). For example: 1 <> 2 would be a true statement. This statement is saying that "one is not equal to 2".

Brackets are used in Access to denote tables and fields. For example: [Inventory].[ItemCount] would refer to a field named "ItemCount" within a table called "Inventory".

Parentheses are normally used for mathematical operations or for separating criteria in queries. For example: [ItemCount] > 10 AND ([ItemNum] = '25' OR [Price] > 50)...in this example, parentheses are used to tell Access what results the query should return; the logic changes based on where you put the parentheses.

Quotes tell Access that data is a literal string (not a keyword or command) of text. For example a query selecting [Item] = "Toaster Oven" would return only the records where the [Item] field contains the exact text "Toaster Oven".

Hopefully this very brief explanation will be of some help.

 

[logosmaid]

Hi Martins,
Thank you for the information! It will help a lot I am struggling with this class because most of the others have worked with some version of Access before or at least something that was related the whole design of the query criteria confuses me somewhat...sigh but thank you for your help!

BJC