Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Alfredomulet

  1. Alfredomulet

    Query question: grouping items

    Hello there, I can't figure it out how to get this result: I have a table with the following values: GROUP PRODUCT 1 A 1 B 2 A 2 A 3 B 3 C 4 A 4 C ... That is, x groups that with two products out of three available. The groups can have two products of the same or different kinds. I'm trying...
  2. Alfredomulet

    Find the datre of the month where the table was loaded.

    Hello everyone. I need to filter my query based upon the record date (RecordDate = day at the end of the month where the specific table was loaded). This recorddate can be different depending on the source file, so, for August 2005 I might have a file loaded on August 25th into one table, and...
  3. Alfredomulet

    Encryption with same key length

    Hello there, which algorithm could I use to encrypt the data in a column keeping the Key length? For example: Decrypted: ONETIME Encrypted: x95sf7w All encryption algorithms I have used (RC2,RC4, DES, 3 DES, AES) use a key lenght over 40. Cheers, Alfredo
  4. Alfredomulet

    Select INTO table "dynamic"

    OK, cheers again lupins.
  5. Alfredomulet

    Select INTO table "dynamic"

    Thanks for your fast response lupins46!! I thought about something like that, but I was trying not to use vb, is it there any other way with just SQL? cheers, Alfredo
  6. Alfredomulet

    Select INTO table "dynamic"

    Hello everyone, is it possible with SQL (select into) to generate a table with dynamic names? Example: Select COL01, COL02, COL03 INTO TABLE_"DATE" FROM TABLE01 where Table_"date" will be a table like TABLE_07112005, tomorrow it will be like TABLE_07122005, etc.. Cheers, Alfredo
  7. Alfredomulet

    Find/Replace Limitations?

    Thanks PHV! as usual it worked great! Alfredo
  8. Alfredomulet

    Find/Replace Limitations?

    PHV, which version of Access do you need to use the Replace function? Can a similar function be used with Access 2000? Cheers, Alfredo
  9. Alfredomulet

    Fill in Blank Spaces between records

    Thank you very much, Eupher, it worked perfectly moving the move statement as you suggest! thanks again, Alfredo
  10. Alfredomulet

    Fill in Blank Spaces between records

    Thanks for your quick reply, Eupher. This table is actualy a raw table created from a set of excel spreadsheets which feed the final (normalized) schema of the database. I found in another thread the following code: Option Compare Database Option Explicit Function IMPORTARFASES() Dim dbs Dim...
  11. Alfredomulet

    Fill in Blank Spaces between records

    Hello everyone, My mind doesn't want to work today.. I'm stuck with this: How can I fill up the blank spaces between two records with the value of the first one? That is, I have a table that looks like this (PRO_DESC & PRO_NAME are the column names): PRO_DESC PRO_NAME Request # Project 1 A B...
  12. Alfredomulet

    Select Numeric characters only

    tnx! it worked perfectly!
  13. Alfredomulet

    Select Numeric characters only

    Thanks PHV, unfortunatelly I've never used access modules, does it work by just saving the module as "getNum" and then running the query??? Sorry for the simple question....
  14. Alfredomulet

    Select Numeric characters only

    Hello everyone, is it there a way to select the numeric characters of a cell using just SQL? My records: Activity_Desc (55) COMUNICACIONES 03-SEGUROS ALIMENTOS Y BEBIDAS - 43 BIENES RAICES (68) CONSTRUCCION (14 ) CARTOGRAFIA My expected results 55 03 43 68 14 Tnxs!!! Alfredo
  15. Alfredomulet

    Replace letters by 0 (zeros)

    Thanks a lot! it worked like a charm!
See more

Part and Inventory Search

Back
Top