Search results

i have a table like this. no. times --------------------- 2001 3 2002 1 2003 2 how i can run a query/vba so that it can turn into 200100 200101 200102 200200 200300 200301

Thank you for your big help!!!!!

Here it is.

Sorry that i can't design the fundamental table because they are assigned by others.

There is a sample database below. I want to input the details of the new students to the student database. A form is set and i want that after i choose a student number, the three subjects will update automatically so that i just need to input the name and teacher in charge of the student.

Maybe I should post my original tables here. (sample) I have some street address and i want to enter the code (TPU,SB,PLOT) if i can. First, they should match the street and find out whether there are any street no match the street address. If the TPU does not contain the street number even it...

SELECT [New Site Address].[code no], [New Site Address].[Site RI no], [New Site Address].[site address], Left([site address],InStr([site address],[name_eng])-2) AS [front words], InStr([front words],",") AS comma, savenumer2(Replace((Right([front words],Len([front words])-comma)),"."," ")) AS...

When i put "WHERE Len(Left([site address],InStr([site address],[name_eng])-2) & "") = 0" in the first query, it gives invalid procedure call again...... It makes me crazy .....

so should i write iif(Left([site address],InStr([site address],[name_eng])-2) is null, 0,1) ?? It gives out all 1 - -!

The query is in #1 .

updated in xls file 1 more is that even if i just want to find out the front words For example: SELECT [New Site Address Search 1].[front words] FROM [New Site Address Search 1] WHERE [front words] = "NO.8"; It also gives the same problem. So I am not sure the whether the function gives out...

Here it is. Firstly, i will match the fire street. In fire street, there are different road no (from_no) i would like to find out there last words equal to from_no. If it is, verify = 1 And I want to extract all the 1 in the query, so that i can finally assign the unique code of the street...

but if the query has a wrong datatype, why the first query can still be run.:( Also, i am no good in vba (i find savenumber2 on the net), can you help me on it please :) Thank you very much!!!!!!!!!!!!

Or maybe I should tell more on what I'm doing here. Please help me with another method if i can't fix the problem afterwards. I have different street address in my tables and i want to match their codes by street number. Firstly i will read the words before the address (including space) -->...

Option Compare Database Function SaveNumer2(ByVal pStr As String) As Long Dim strHold As String Dim intLen As Integer Dim n As Integer strHold = Trim(pStr) intLen = Len(strHold) n = 1 Do If Mid(strHold, n, 1) <> " " And Not IsNumeric(Mid(strHold, n, 1)) Then...

The same...invalid procedure call

SaveNumer2(XXXX) is a function that remove everything except the first number . I have tried not using the function before but the problem remains. I am not sure where after using instr(), the query can't use "WHERE" anymore.

The first query

Not works.:( What a strange problem :banghead:

NO, it can't work.