Selasa, 30 Juni 2015

[MS_AccessPros] question about adding a column to a query

 

I am not sure this is possible or not but thought I would ask

I would like to pull in data from a table, then have it add a couple of columns so if say Diet is not blank(or has a specific result) it would put a 1 in the column field for Diet Educ, if Physical activity is not blank(or has a specific result) then it would put a 1 in the PA educ column and if they have both then it would put a 2 in the both educ column.


Is that possible and if so what is it called, or how would I write such a query?

Appreciate the help.

Patty

__._,_.___

Posted by: pattykf@cox.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar