Search results

Hi I am trying to replace the numeric values of a field with a text in querry using Choose function, something like this aa5: Choose([a5]-1="one";[a5]-2="two";[a5]-3="three";[a5]-4="four") But it is not giving me no results :(( I am missing something but I do not what. Maybe I should use...

Hi I have a form where I am entering lot of records where only the date is different . In order to shorten this I need a querry that will (activated with a button on the same form) generate records in some other table (or in the same) with those records entered in the form and will have a field...

Within a formula in querry beside other values, I need to have a logaritham of some records, but the Log function is giving me other (higher) results then for exp. in Excell or with calculator !? I hope someone can spent little time to explain it what I am doing wrong! Thanks in advance!!

Hi I have a problem, I need to make quarter reports but they should be different from the default ones, for example first quarter should be from December, November and January. The standard quarter querry is using this format: datum By Quarter: Format$(dnevna_lista.datum;'yyyy" Q"q ')...

I have a database that have few tables with records, every table has a field with names for every record entered, I am trying to make a form, where I have combo box made from that field with names, and command buttons for oppening different forms and reports of the particular name that I choose...

Hi, I have telephone records with duration measure in format hh:mm:ss, I want to get a sum of them, so far I understand that first I have to transform the durations in seconds, then made a sum of them, at the end transform the seconds at the starting format hh:mm:ss. Can anyone help me? Thanks!