Search results for query: *

table: sales field: manufacturing code Data inside manufacturing code: IM2, IM, SIS, SIS2, PASSO2, APC2, SeeFei2, SeeFei I want use the SQL to display the data with 2 at the back only. I know there is a stupid to do that, i.e. ....where ManufacturingCode= "IM2" or...

Something very interesting issue to think of. Personally, i believed that there will be limitation in Ms Access like Ms Excel on the database it can store. The maximum row that Ms Excel can go is until 65536. So, what if the database in Ms Access is reaching maximum i.e. cannot store additional...

just wanna to know somethig about Oracle as i'm new to it. As i know, Oralce 7 doesn't support INNER JOIN and Oracle 9 can. My computer is installed with Oracle 7 client. The server is running Oracle 9 server. Can i use the INNER JOIN in my SQL*Plus, Oracle 7 using INNER JOIN command in my SQL...

tblPart = Part_Num,Business_Unit_Id tblOrderDetail = Part_num,Business_Unit_Id tblCorp = Business_Unit_Id I have three tables as stated above. I want to equi-join tblPart.Part_Num = tblOrderDetail.Part_Num and tblPart.Business_Unit_Id = tblOrderDetail.Business_UnitId and...

In the WHERE clause.... .... where area = "india" or area "china" can be equivalent to: where area IN("india","china"). What if: where area like "a*" or area like "b*" How to put the Like and IN command together?

hi, just want to make sure is it my conversion is correct regarding the MS Access SQL and "Native" SQL conversion regarding the join: Here is the SQl from MS Access FROM (ASIA.PROD_ORDER_DETAIL_ASIA INNER JOIN ASIA.PART_ASIA ON (ASIA.PROD_ORDER_DETAIL_ASIA.BUSINESS_UNIT_ID =...

hi, just want to clarify something. Is it INNER JOIN is same as EQUAL-JOIN. If not, what is the different

as i understand, if i want to build up a new table using query, i can put the INTO tblName somewhere in the query to build up a new table. Now i'm writing the Pass-through Query to obtained the data from Oracle database. So, i need to use the Oracle-syntax to write out the query. Next, i...

environ("UserName") is working on my computer. However, when my friend buy a new computer and copy the MS Access file i developed but it's not working in his computer. I go to Tools->Reference to check maybe his computer is missing any dll or ocx files. But he have all the files in his...

hi, i used a make table query to make up a table. In one of the column, i want to make it as combo box with only two values: Yes, No. CAn i do this in the Make-Table query?

hi, can i know how to get the number of sheets in an active excel workbook

i have difficult to understand the Help file in MS Access 2000 talking about PAss Through Query. Can anyone here explain using plain english? This is the text in the MS Access 2000 help file: An SQL-specific query you use to send commands directly to an ODBC database server (such as Ms...

i am writing one make-table query. I want to add another two fields on the new table. Match (Yes/No) and Comment (Text field). Is it possible? Thanks

Can i know how to check the ODBC data source? I have one ms access file. The tables are connected to ODBC data souce. When i tried to recreate the table and select the ODBC, the ms access asked me to locate the DSN server, in this case i suspect it should be something like UNC path. I am not...

in the query, i put this line of code in pone of the field: Attrition: IIf([BadgeNoForecast];Yes;No) But the result displayed when i run the query is -1 or 0. But i don't want this one. I want it's either displayed "True" or "False". Please don't ask me to do in this way...

two tables: tblEmployeeForecast, tblEmployeeActual Fields in tblEmployeeFOrecast: EmployeeNoForecast, EmployeeNameForecast, CostCenterForecast Fields in tblEmployeeActual: EmployeeNoActual, EmployeeNameActual, CostCenterActual eg data for tblEmployeeForecast: EmployeeNoForecast...

i have one Make Table query. One of field is Location. It is used to let user to key in the Location such as China, US etc. On that field, i put the following syntax on it: Location: [Please enter Location}. But when i open up the table in Design Mode, i noticed that the Data Type for that...

HI, I am looking for the correct syntax only as i can't figure out. One table with 3 fields. All are checkbox Test1,Test2,Result Result will become true only if Test1 and Test2 are true. So, i use the =Iif(Test1 = "True" and Test2 = "True&quot...

i want to create a button that is similiar to the File->Get External Data->Import. By only clicking on this button, the Import Dialog box will appear to let me choose the file i want. After i choose the file, the Import Object dialog box will appear to let me choose whatever the table, query etc...

anyone here knows how to decrease ms access refresh time when connected to ODBC data source Thanks