Search results for query: *

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

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

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

OK, cheers again lupins.

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

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

Thanks PHV! as usual it worked great! Alfredo

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

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

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

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

tnx! it worked perfectly!

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

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

Thanks a lot! it worked like a charm!

R937, Thanks a lot for your response. It includes sometimes numbers, indeed. cheers, Alfredo

Hello there, thanks for the previous responses. Is it there an easy way to replace one character of a field by 0 (zero) using just SQL? For example: TXN_AMT 000024584862R 000000473929J 000000012929A 000005013141S to TXN_AMT 0000245848620 0000004739290 0000000129290 0000050131410 The length of...

Hello everyone, how can I select all the characters from a field after the second comma (or space)? I have: FULL_NAME ALFREDO JOSE PEREZ REVERTE and I would like to select everything after the second space, that is: PEREZ REVERTE. Cheers, Alfredo

Hello everyone and Happy 2005, Is it possible to record the usage of Excel, Powerpoint, Word, etc..., that is, for monitoring their use to be able to know when the applications are launched. Thanks and regards, alfredo

Thanks entaroadun, i haven't look at it that way, it makes perfectly sense. By the way we're using BO, is it one of the tools you're talking about? cheers, alfredo