query expresion

[iraidotel@yahoo.com]

Hello, experts access
please help her, I want to create a formula to the query as follows
The attached file table

so thank you

regards, Ira

 

[CJ_London]

something like

SELECT *, switch(rec is null,"C",rec>=94,"A",rec<94,"B") as ClassData
FROM (SELECT * FROM dbo_collar C INNER JOIN dbo_listFile L ON C.hole_id=L.holeID) X LEFT JOIN dbo_ListPDF_Logging Y ON X.hole_id =Y.hole_id

 

[iraidotel@yahoo.com]

something like

SELECT *, switch(rec is null,"C",rec>=94,"A",rec<94,"B") as ClassData
FROM (SELECT * FROM dbo_collar C INNER JOIN dbo_listFile L ON C.hole_id=L.holeID) X LEFT JOIN dbo_ListPDF_Logging Y ON X.hole_id =Y.hole_id

may i ask her access files, because I tried in 2007 still can not access.

thank you ,

 

[CJ_London]

I presumed you were accessing sql server table

add this as a new column to your query - you should be able to copy and paste

ClassData: Switch(Nz([dbo_List PDF_Logginghole_id],"")="","C",[rec]>=94,"A",[rec]<94,"B")

 

[iraidotel@yahoo.com]

I sent her file access, can kah help me to fill his expresion
because I try not succeeded

thank you