tuzojazz

Hi:Thanks but char_length does not work in access.Is there a function that works in access?

Hi:suppose I have this tableCUSTOMERS---------------------Name---------------------JohnGabrielGeorgeKenI need to make a query to get customers where the Name length is equal or greater than 6Name--------------------GabrielGeorgeHow Can I make this query or/and where can I find information about this kind of query?Thanks!!

Hi:I'm programming an aspx in visual basic.net code in notepad.From my aspx I'm trying to make a query to a database that is in access but I get aSystem.Data.OleDb.OleDbException saying Nz function is not defined.The query is something like thisSELECT Nz(SUM(Total),0)FROM CargoDWHERE Folio=4224When I try the query in access it works but from my aspx not.What could be wrong?What can I do?Thanks!

Hi:I have this querySELECT SUM(Total) FROM CargoD Where Folio=100there are no records in the table "CargoD" Where Folio=100 and I get a null resulthow could I write the query in order to get 0 instead of null?Thanks!!

Hi:I have a table named "Calls"Calls----------------------------Id Date----------------------------2 04/04/2006 11:33:073 04/04/2006 11:35:27-----------------------------Both records have the same date but different timeWhen I make this query I don't get records-------------------------------------------------SELECT Id, Date FROM CallsWHERE Date BETWEEN #4/4/2006# AND #4/4/2006#-------------------------------------------------Why I don't get records If all records in table "Calls" have 04/04/2006 on column "Date"?Thanks!

HiI have two tables: Employees_Norway and Employees_USAEmployees_Norway:Employee_ID E_Name-------------------------------01 Hansen, Ola 02 Svendson, Tove 03 Svendson, Stephen 04 Pettersen, Kari Employees_USA:Employee_ID E_Name------------------------------01 Turner, Sally 02 Kent, Clark 03 Svendson, Stephen 04 Scott, Stephen In order to list all employees in Norway and USA I'm using this query:------------------------------------------------SELECT E_Name FROM Employees_NorwayUNION ALLSELECT E_Name FROM Employees_USA------------------------------------------------I get this resultName ----------------------Hansen, Ola Svendson, Tove Svendson, Stephen Pettersen, Kari Turner, Sally Kent, Clark Svendson, Stephen Scott, Stephen What more does need my query to get the result in alphabetical order?Thanks!!