Hello,
I have a Access SQL statement as follows....What I am trying to do is to make sure that the results are displayed in a new form or in a popup message box? is this possible without using VB? Please help...
Thanks.
Select FirstName, LastName, Age, Gender, City FROM CustomerInfo;
LoneStar
Last Activity: Oct 27 '09, 08:29 PM
Joined: Nov 9 '06
Location: Chicago
-
Sql Query Display Options?
-
That worked perfectly! thank you so much! -
I am not too savvy with VB..Any suggestions?Leave a comment:
-
Combining Rows-Opposite of Union
Hello,
I am tyring to combine several rows based on matching information..Fo r example i have the following table.
IOSC: FEATURE:
00029 LH
00029 SWFTERM
00029 WATS
00031 1PTY
00031 BUS
00031 FR
00031 LS
00031 SWFBOTH
00031 TC
00573 FAXTHRU
00963 1PTY
00963 BUS
00963 FR
00963 LS
00963 SWFBOTH
00963 TC... -
If I understand you correctly you can prob use the following SQL statement.
SELECT <Supplier> FROM <table_name>
WHERE <Column Name> IS NOT NULL, <Column Name> IS NOT NULL....and so on...This is assuming that each Specie is listed in a separate column.
Hope this helps.....Leave a comment:
-
Thanks! that worked..Leave a comment:
-
I got it to work....well sort of...it keeps on giving me a data type mismatch error! Any sugguestions... .....Leave a comment:
-
{SOLVED} Help with query output
Hello...
I have the following query which gets input from user entered information. When this is executed the results is displayed in a dynaset. What I am trying to figure out is if there is a way to display the results on the same form or a msgbox. Please let me know if you can help.
Thanks..Lonesta r
SELECT KenanCrmTable.C omponentIOSC, KenanCrmTable.C omponentDesc, KenanCrmTable.M emberType, KenanCrmTable.P ackageType,...
No activity results to display
Leave a comment: