Recent content by boge

There is another way for this, with another table (with two columns - one numbers, other the text values) and then relationship one-to-manny between colums with numbers, and finally lookup-querry :)

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 It seems that the complete solution is in another thread at the forum http://www.access-programmers.co.uk/forums/showthread.php?t=79731&highlight=replace+record Thanks anyway Doc_Man!

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

Well, it is a to long time since I was learning this in high school and I am not sure that I understood you, but it works :D :D :D Thanks again!

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

This is working fine it seems, it just needs some time (about 7-8 sec) to show the results. I have more then 15000 records in that table so that is probably why it takes some time. Both ways are working! I will probably see more what way will be more convinient, EdFred way is much more...

RuralGuy, I have to check a little more to see if the results are correct - it seems ok so far, but the problem now is that the querry does not separate the years, it shows sums of all the quarters no matter what year they are

I guess you meen first to make a querry for monthly reports then another querry to make a sum report for the months I need to ?

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

Thanks A Lot To Both Of You !!!

I tried with Combo box made from Querry and it worked :D www.korab.org.mk/db3.zip

Combo box Yes there was problem with ComboBox, but I cleared it now - it has one column, but the result is similar as previous, it is not working :( Here is the example database www.korab.org.mk/db2.zip that I am using.

Thanks for your time! I am afraid it is not working, when I click the command buton it shows "Runtime error 2102 - The form name "3" (that is the ID number of the record I am lookin up in combo box) is misspelled or refers to a form that do not exists" When I clik Debug, then it shows...

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