ECDL module 5

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, could any1 help me with the following question

When running a query a certain field may be required for the query to
function, but is not required to be displayed in the query result. What
simple action is required to ensure that the field is not shown in the query?

i need the answer asap thanks
 
Hi lilac,

If you do not include the field in there WHERE clause in your SELECT list,
the condition is used but the field not included in results. For example if
I have a table Customers with 3 fields - CustomerName, CustomerPhone and
ZipCode and only want to return customers from zipcode 12345, and only want
to see the name and phone:

SELECT CustomerName, CustomerPhone from Customers WHERE ZipCode = 12345
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run 2nd query using results from 1st query 0
Query Criteria 2
NOT function not working - can prove with screenshots 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Really need HELP on ECDL questions 2
Displaying query result on the same form as selection fields 6
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3
Access Dcount (multiple criteria) 3

Back
Top