Recent content by erxefera

Hi! I have big problem, How to multiply records according to number given one field? I have one field which gives me a number of people. After operation first record of the multiplying list should have addditional information how many records were there.. Example Record: A(Name)-3(People)...

Yes, but i don't want to make it manually, if i have 169 keywords, The search has to be done automatically but HOW???

Hi! Is it possible to make such query which will find all records that have name like keywords. These words are collected as s dictionary in another table in column name. Is it possible to make just one query or vb script that will search through all records using all of keywords given in...

Thank's for that example but i can't see here any possibility for Name= Smith Or Parker....search

HI! I'm trying to figure out, how to make seach form with one text field, that will accept OR statements. I have one table with fields name, category, and description. Is there any chance to make search like this: User will put "part of the string" OR "part of the string2". Result will be the...

Hi ! I have big problem in putting subtract function in sql query i have 2 tables In the first table i make "sum of amount" in each "category_name". In the second table i have 2 columns with the "category_name" and "available_amount". I make query with join on "category_name" and i want to get...

Hi I have big problem and i have to find solution within one hour I have numbers like this "space"numbers"space"numbers" I would like to cut the spaces I know there is trim function but i'm pretty beginner, i read help but i can't still use it and trim will work only on first space? I'd be...

Hi! Can anyone help me how to create query selecting only the records starting with the numbers? Thanks a lot in Advance

HI! I have big problem I have telephone number field like this Tel(XX)XXXXX - X are numbers I have to split it into two columns and skip brackets like this Column1 - Tel Column2 - XXXXXXX Is it possible? I have no idea how to manage it...I'd be very thankful for any examples ? Or...