Search results

  1. S

    need help

    The_Doc_Man, isladogs thank you for the great help. June7 thanks.
  2. S

    need help

    isladogs, no i did not follow your suggestion.
  3. S

    need help

    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...
  4. S

    make tables the same

    All hints and suggestions are so helpful. isladogs, the link is so awesome.
  5. S

    make tables the same

    The ID is an autonumber. Can it be done based on the data and time?. Like do insert if the name1, name2, mydate, mytime in source table does not exist in destination table. How that would look like?. There are no dependent tables on the ID.
  6. S

    make tables the same

    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
  7. S

    intervals among rows

    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...
  8. S

    Need query for data extraction

    it is wrong. this is right. ID MyId Col1 Col2 mydate Col3 ---------------------------------------------------------- 3 aaa1 TB xc datex3 bb 4 bbb1 TA xc datex1 cc 5 ccc1 TA xe datex2 ee 6 ddd1 TB xf datex1 ff 8 eee1 TB xh datex1 hh . .
  9. S

    Need query for data extraction

    Hi JHB, The Sampledatabase (2)1.accdb produces unexpected output. I will work on it, I begin from your second upload.
  10. S

    Need query for data extraction

    I meant like if the input con_tbl table instead is (see the col1):: ID MyId Col1 Col2 mydate Col3 ---------------------------------------------------------- 1 aaa1 TA xa datex1 aa 2 aaa1 TB xb datex2 aa 3 aaa1 TB xc datex3 bb 4 bbb1 TA xc datex1 cc 5 ccc1 TA xd datex1 dd 5 ccc1 TA xe...
  11. S

    query soft indexing

    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.
  12. S

    Need query for data extraction

    JHB and all, how about if the input con_tbl table, in the col1, substitute 'TB' for every '2' and 'TA' for every '1', applying the same rules?. This is another table that differs a bit but make the query more difficult. Like when 'TB' and 'TA' exist for a given MyId, select the one with 'TB'...
  13. S

    Need query for data extraction

    June7 , two date1x, datex1 and datex1 can be different dates. date3x>date2x>date1x. I will try your suggestions.:confused:
  14. S

    Need query for data extraction

    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...
  15. S

    query help

    Thank you, the UNION query works well, the only thing is that the result is sorted and that is not desired at all times. How to disable the sorting, or add an increment ID to the UNION so that first row shows up on the top at all times?.
  16. S

    query help

    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
  17. S

    fonts

    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.
  18. S

    repair/compact

    frequent continuous opening, inserting, closing,.. repeating the same thing whole day. Need a more durable engine. mysql is good but bad thing it is not free. any ideas?.
  19. S

    repair/compact

    Is the database split? yes, it is. Does each user have his own personal copy of the FE? yes.
  20. S

    repair/compact

    my VBA compact/Repair causes the size to go from almost 1.5G to 1G. What is the real size, 1G?. I have to repeat this action everyday. Is this Ok?. Only need this database for near future, then there we will be an upgrade.
Top Bottom