Search results

Got a table1: Got a table2: ID is autonumber. Trying to insert from Table1 field1, ... , field7 if field1, ... , field7 do not exist in table2. my query: INSERT INTO table2 ( field1,field2, field3, field4, field5, field6, field7 ) SELECT a.field1, a.field2, a.field3, a.field4, a.field5...

got db.mdb\tableA and db.mdb\tableB. Like to merge them, A->B and B->A, make them the same so that they both have same records. what is best query to do so?. table A & B have exact same fields.: ID name1 name2 mydate mytime name3 nam4

need a query that finds number of days in between several rows. Same col2 as of the row with the highest date. input: table1: mydata col2 mydate "AAAA" A1 11/20/2013 "BBBB" B1 11/21/2014 "AAAA" A1 10/01/2013 "CCCC" C1 08/01/2016 "AAAA" A1 11/15/2013 "BBBB" B1 09/21/2014 "BBBB" B1 07/21/2014...

Is it possible to index a field in query?. Like give it a uniqueness like we do it in an actual table setup?. access 2003 and above.

Someone left a table that some how is complicated for me to query the data I want to resemble the output. struggled with the transform then the cross tab, not much luck, could not do it. I need a query that from the input con_tbl table i get the output table. input con_tbl table:: all fields...

Let's consider a table as follows. In: A B C A1 A2 A3 B1 B2 B3 C1 C2 C3 need an Access db query to get this output?: Output: A A1 A2 A3 B B1 B2 B3 C C1 C2 C3

in excel 2003, or even 2016 how to make the barcode fonts compatible to the Access fonts?. The same font in the excel takes larger space. If I make font size smaller to fit the cell, the font becomes too small. The same cell size in ACCESS, the same font size fits well and scans well.

My local PC has only Access 2010, the remote file is mydb.mdb file. Like to create a .vbs or .bat file on local PC so that my local Access 2010 can repair/compact the remote .mdb file periodically. any straight forward way to do this?.

in access database, it is possible to create doubly linked tables?. Linked Table A (db3) --> Linked Table A (db2) --> Table A (db1) Is it safe?.

In my access 2003: When I execute below query, the query become read-only and I have to make the Field2 in T2 unique to by pass that. How to change the query so that I would not need to make it T2.Field2 unique, any way?. select T1.*, T2.Field2 from T1 left join T2 on (T1.field2 = T2.field2)...

Access database 2003: Table1 (T1) has the following fields: 1 n1 n6 n7 n8 2 n2 n6 n7 n8 3 n3 n6 n7 n8 Table2 (T2) has the following fields: 1 n1 n10 2 n2 n11 3 n1 n12 Need query to return the following: n1 n6 n7 n8 n12 n2 n6 n7 n8 n11 n3 n6 n7 n8 "NA" Tried everything in many ways...