not sure would be appropriate to ask a different question but I'm asking anyway...
I have a table that was made using a stored procedure (make-table query). Data from this table was pulled from mutiple queries. Now, I need to update cases (or subjects) in this table (tblfuzhongtemp ) from the original source query (QryFuzhongTemp ). I tried the append query but keep getting cases doubled (see below).
INSERT INTO fuzhongl.tblfuz hongtemp...
Fuzhongli
Last Activity: Mar 20 '07, 11:17 PM
Joined: Mar 19 '07
Location:
-
Sorry for the confusion. I had to ask our IT people about this. We do use Access (as a front-end, and SQL server as a back-end). That's all I can tell.
would this help? thanks. fuzhong...Leave a comment:
-
thanks.
I am working this off a query. I cut and pasted the code iif(Subject.SGe nder = 0, "Male", "Female")) into the Column (in the Sgender row) and put SGender as Alias. I recevied the following message:
ADO error: 'iff' is not a recognized function name. Did I do something wroing? Could you let me exactly how this code should be implemented? many thanks again. fuzhong...Leave a comment:
-
Sorry that I did not make it clear.
The name of the table is Subject which has a field named Sgender which I would like to convert the number in this field into a new field (e.g., SgenderN). We use SQL. I am not an expereinced user. If you could tell how I can do this in SQL that would be great. Many thanks again.
fuzhong...Leave a comment:
-
How do I lookup the corresponding value of a numerically coded field?
Hi,
I have a number field coded as 0 and 1 (representing male, female). I would like to convert this integer into text (i.e., 0=male, 1=female). Could you help? Please be specific.
I am using Window XP and dob.
Many thanks in advance.
Fuzhong
No activity results to display
Leave a comment: