Search results

something like: select sum(sex ),diagnose from MyTableName group by diagnose anna

Hi, The way I like to work out these queries is as follows 1.) create the select query using the interface of Access 2.) goto the sql view of the select query and add the following SELECT * FROM ("your previous created sql") AS TEST 3.) run the query (output = previous output) 4.) open the...

If you use VBA it is = Left([FieldName],5) If you use the expression builder = Left([FieldName];5) A little access annoyance!!!! anna

it's fields e.g. Retrieve Name of your column CurrentDb.TableDefs("T1").Fields(0).Name OR CurrentDb.TableDefs("T1").Fields("ID").Name gives in this case, as result "ID" For the value use CurrentDb.TableDefs("T1").Fields(0).Value OR CurrentDb.TableDefs("T1").Fields("ID").Value anna

In the VBA interface go to tools>options select the "GENERAL" tab under "ERROR TRAPPING" see if "BREAK ON ALL ERRORS ISN'T CHECKED" anna

use the following functions mid() left() instr() instrrev() right()

Hi, try to build your code that the result when debug.print is something like INSERT INTO FIXASSET (BARCODE, [ITEM NOTE], CATEGORY, [G-CODE], [EMP#], MFLAG ) VALUES ('06116', 'GPVA5', 'LT', '033', '20069', '-1') no quotes around the sql statement no ; at the end use VALUES instead of SELECT...

Hi guys, Does anyone know if there is a way to use an SQL Passthrough Query between two Access db's. It works when I use Oracle as a backend DB but I keep getting errors when using Access as a backend DB. TNX, anna

Instead of using this format to refer to your columns [TableName].ColumnName try using this one [TableName].[ColumnName] One of the names of your column might be recognized as a reserved word in Access. anna

Hi, When I want to generate different reports but use the same layout I usualy do this: Set the Record Source in the Report (design Mode) to "". Just build your SQL-string in the selection form. Than set the report.RecordSource = strSQL. anna

Hi, You will have to use a right or left join for this. It is possible to do this using the query design interface in Access. Just select the link between to table. Click your right mouse button and select "Join properties". You get a selection screen that, I think speaks for itself. anna

Hi, Try something like the following query. I have tested it and it works just fine. There is one "but": This only works if the second select statement returns exactly one row!!! SELECT Count(NetTime) FROM myTable WHERE NetTime > ( SELECT Avg(NetTime) FROM mytable ) If this is not what you...

Hi Terry, You can use option groups. Create such a group with two option buttons. Give the buttons resp. the values 14 and 30. To retrieve the value the user has chosen: Me.OptionGroup.value greetZ, anna

Hi, you can use DAO or ADO to do this. I, myself, prefer ADO. I'll give you a breef example. include the ADO 2.5 reference in your DB 'create connection variable for each db dim conFirstDB as new ADODB.connection dim conSecondDB as new ADODB.connection 'create recordset for each table/query...