Access 2007 Queries

[Breeze123]

I have 2 queries I am trying to run, The first is to get all Units on the
fourth floor only in the query and the first number is 4. How do I do this
correctly. I tried 4, and 4*.

The second one is I need to figure out what 15% of the rate is and I don't
know where to start?

 

[John W. Vinson]

I have 2 queries I am trying to run, The first is to get all Units on the
fourth floor only in the query and the first number is 4. How do I do this
correctly. I tried 4, and 4*.

See the online help for LIKE. You don't indicate anything about the structure
of your table or how the unit and floor are stored so it's more than a bit
difficult to answer. If you're looking for records where the first character
of a Text field is 4, then

LIKE "4*"

will do it for you.

The second one is I need to figure out what 15% of the rate is and I don't
know where to start?

15% is a way of representing the number 0.15, so

[Rate] * 0.15

would be fifteen percent of the rate. Again... you can see your database; we
cannot, so I don't even know if you have a field named Rate!

 

[Breeze123]

Thanks so much I hate to ask but I am also trying to figure out how to get a
result to appear if the value of sales is 0 for that person? And finally how
to get the highest and lowest value in a query result? If you could help me
out that would be greatly appreciated as well. And again thanks.

 

[John W. Vinson]

Thanks so much I hate to ask but I am also trying to figure out how to get a
result to appear if the value of sales is 0 for that person? And finally how
to get the highest and lowest value in a query result? If you could help me
out that would be greatly appreciated as well. And again thanks.

By creating an appropriate query for the structure of your table.

If you would like help doing so, please post a description of your table with
the fields and their datatypes.

You can see your screen; we cannot.