Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
msquery
I am interested in creating a field in query based on the values in existing fields. If the value in field A = 'Y' then insert value in field B, else do nothing. I get syntax errors, but nothing that is helpful to correct the 'error'. -- troestj |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
msquery
If you are trying to return to Excel, only those items from column B of the
file you're interrogating that have a corresponding "Y" in column A, then you can do this by recording a macro to import both columns A and B, with the condition of only importing rows containing a "Y" in column A, and then deleting column A once it's in Excel......... hth Vaya con Dios, Chuck, CABGx3 "troestj" wrote: I am interested in creating a field in query based on the values in existing fields. If the value in field A = 'Y' then insert value in field B, else do nothing. I get syntax errors, but nothing that is helpful to correct the 'error'. -- troestj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
msquery in Excel 2007 | Excel Discussion (Misc queries) | |||
MSQuery editing source data? | Excel Discussion (Misc queries) | |||
MsQuery Documentation | Excel Discussion (Misc queries) | |||
MSQuery "disappearing" | Excel Discussion (Misc queries) | |||
Multiple ODBC Database lik in one MSQUERY query | Excel Discussion (Misc queries) |