Recent content by skmaddur

Logic error. it works fine, if I change the field1 search to also be Like function. Thanks ranman, in helping out with my 1st succesffull ms access 2007 program. :) Basically, my code now looks like the following; SELECT Icd10cm_order_2016.OrderNumber, Icd10cm_order_2016.Icd10CM...

When all blank fields, I want it to return all the rows in the table.

Thanks for the response. Just to clarify; An example; Field1 = 34 ; returns the row 34, with the values of 4 columns (number, icd, short desc, long desc) Field 2 = A0; does not return the rows from the table that match this text.

SELECT Icd10cm_order_2016.OrderNumber, Icd10cm_order_2016.Icd10CM, Icd10cm_order_2016.ShortDesc, Icd10cm_order_2016.LongDesc FROM Icd10cm_order_2016 WHERE (((Icd10cm_order_2016.OrderNumber)=[Forms]![SearchICD10CM]![OrderNumber]) AND ((Icd10cm_order_2016.Icd10CM) Like "*" &...

Hi, I am a novice to access 2007. Just doing some db work in spare time. who doesn't need some more sql experience ?