Thanks Dawn. I am putting it in the criteria field. It might just be a programming error with the testing application. Because I have never answered it right in the application, even after all the ways that you discussed. I should not have that problem with the test on Saturday.
 
Jim Wagner

"Crosier, Dawn" <[EMAIL PROTECTED]> wrote:
"LA" would be the correct answer.  Are you sure you are placing it directly under the State field in the criteria row?
 
If you are going to use Like, you need a wildcard character.  Like "*LA*" will find anything which has an LA contained in the middle, such as Larson, Noland or Law
="LA" provides the same results as the "LA" criteria, it could be considered more correct.
 
 
This message was posted to a newsgroup.  Please post replies and questions to the group so that others can learn as well.
 


From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jim Wagner
Sent: Thursday, November 17, 2005 9:29 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] simple query question

I am going to take the certification test for access this saturday. I have preparing with MeasureUP tests. I continually get one question wrong. It seems so simple and it might be a programming problem with the software. It asks to query for LA  in the state field. I have tried to use, Like "LA" and ="LA" and "LA" None of them are right according to the test. what is the answer?
 
Jim Wagner


Yahoo! FareChase - Search multiple travel sites in one click.


Please zip all files prior to uploading to Files section.




SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming


YAHOO! GROUPS LINKS




Reply via email to