Recent content by Ai_Jun_Zhang

Hi! I have two tables Atable and BTable and both have a field called AcctNo. In Atable, it is type of Number and in BTable, it is type of Text. When I do a join with these two tables select * from Atable, BTable where Atable.AcctNo=Btable.AcctNo I get error saying "type mismatch". My...

I found the solution. It is SELECT Year & format(Month, '00') FROM myTable;

How to do that in the select statment? Hi! Thank you very much for your reply. I think the code you give is vb code. I would like know how can I combine columns in the select statement with the format that I like to have? Please advise Aijun.

Hi! I have a table called myTable and it contains two fields Year and Month. Both are type of integer. Now in my select statement, I like to combine these two fields in to one and name it as period and it will have the format, for example 200501, 200502, ..., 200512. How can I do that in...

Hi! Is it possible for me to alias the fldGroup to Function Group? How do you alias a field name to a name that contain a space? Please advise. Aijun.

Is there a way to use the reserve name in the select statement? Hi! I can use the fldGroup in the table. But when I do the select statement, I would like to fldGroup is presented as Group to users. So, in my select statement, I have Select fldGroup as Group from myTable This gives me error...

Hi! In the field names of my table, I have one field called Group. However, it is a reserved word in MS Accesss. My question is: Is there any way that we can use a reserved name in a field name? Please advise, Regards, Aijun.