Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / May 2007

Tip: Looking for answers? Try searching our database.

SQL Select Command

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Wahab - 08 May 2007 08:34 GMT
Hi
please help me in writing the SQL "SELECT Brand, BrandDescription" ,  &
txtLoc & "FROm locationMap"
I hve one table  name LocationMap with the fields  Brand, BrandDescription,
RA1, RB2,RC1,RD2,RE4,RF2,RG2
I have one form the with one text box name txtLoc where value I m getting
from the combobox , which can be RA1 or RB2 or RC1 and so on.I want to write
one SQL to select fields Brand,  BrandDescription and only one column which
value will in txtLoc  how I will do this one?

Thanks in advance
Alex Dybenko - 08 May 2007 11:08 GMT
Hi,

try:
"SELECT Brand, BrandDescription, " & txtLoc & " FROm locationMap"

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hi
> please help me in writing the SQL "SELECT Brand, BrandDescription" ,  &
[quoted text clipped - 10 lines]
>
> Thanks in advance
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.