Search results for query: *

Thanks a lot mintjulep, as for your question SkipVought. Column D must be 2 because it means that column A is in the 2nth position comparing with column B and C.

Hello, my situation is like this: I have four columns in Excel (A, B, C and D). The first three ones contain some values, and in the fourth column, column D, I would like to have the ranking (positioning) of the first column, column A. For example: A=10, B=20, C=7 and column D must be 2 (which...

when you past a larger texts (more than one page) the columns are not the solution. However, i found another solution (Tables). Thanks a lot.

Hello, I want to put two parallel text (translated subtitles) in a single word document, so I could see them in the same pages as I need to do some comparisons. Regards, Tonny-pr

thanks a lot

Hi, can anyone help me on changing the case of a whole table or just a particular field. I am interested to have all the existing data in uppercase, and to make it as a rule that coming entries to enter the database in uppercase no matter whether the capslock is on or not. Thanks in advance...

thanks a lot, it helped me a lot

hi to all, my case is like this: I want to exctract some characters from field1 and some from field2 in order to create another field based on that. I try this; Left([field1],3)& left([field2],3} but it takes all the all 3 characters from left. I am interested to take just the third one, not...

Thank you very much. Best regards, Hysen

hi guys, I have a problem with my reports. When I want to open a report this message appears : " There was a problem retrieving printer information. The object may have been sent to a printer that is unavailable". I checked with my printer and i can print documents without problems. But I...

Hello, I fixed that as you proposed me. The problem now is that I want to create a report based on this barcode number. How could I do that? regards, Hysen

Thanks PHV, that helped me, but partially, as in my form I have just a asset category ID item and that appears in my barcode text box and not the three character asset category description. I have another question, how is this possible to be done in access tables as well. Because when I open...

Hello, I have a form based on the table with these fields: 1. Fixed asset number (ex. 354) 2. Asset category (three characters, ex.107) 3. Location of the asset (two options: Television or Radio) 4. Origin of the asset (two options: Donation or Investment) 5. Barcode number What I want, is...

Hello, I have a form based on the table with these fields: 1. Fixed asset number (ex. 354) 2. Asset category (three characters, ex.107) 3. Location of the asset (two options: Television or Radio) 4. Origin of the asset (two options: Donation or Investment) 5. Barcode number What I want, is...

Thanks jrbarnett

Hi, is there a possibility of replacing order of the characters within a field, for ex: 11-22-33 to be like 33-22-11 Thanks in advance, Hysen

Jeremy, it worked great. Thanks again. If u don't mind, I have another question regarding to this. Well, the form is ok. But the form is based upon a table, where I the new field stays blank. So, the results does not affect the table. What could be the problem?

Thanks Jeremy, thanks indeed. Could I also, have them separated with commas? Hysen

Hello, how can i have all the data from two ore more different fields in one new field, ex: "names" in the namefield and the "surname" in the surnamefield. thanks in advance, Hysen

thanks jrbarnett, i tried what u told me, but no success.:( Hysen