|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
Ajax Application Generator Generate database and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!
|
|
#1
September 24th, 2003, 11:45 PM
|
|||
|
|||
using CASE in MS Access select query
Hi,
I'm using 2 tables A & B. The structure is a: emp_id, name, value, check b: emp_id, name, value check field in table A is yes/no field. Question: An sql query which can, If check= 'yes' pull record from table B else from table A, for emp_id = User entered Id I'm using Access 2k. The result should be compatible.
|
|
#2
September 26th, 2003, 08:51 AM
|
||||
|
||||
|
arvind,
Why have you got the same three fields in two tables? (emp_id, name, value,) Give us an idea what you are trying to do. Post a copy of your database Regards,
__________________
Regards, John A
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > using CASE in MS Access select query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
