Search results

Hello i tried to enter a field in query as follows izr4: DCount("*";"[sourcetbl]";" sourcetbl.IDfield<=" & [sourcetbl].[IDfield]) but it returns only the IDs selected by query, i would like to have "renumbered" IDfield with exclusion of results not included in query, but still...

Hello im still working on rownumbers. I think im quite close to the solution now. I would like to use something like SELECT (SELECT COUNT(t1.SourceID) FROM [SourceTable] t1 WHERE t1.SourceID<t2.SourceID) AS RowID, t2.field2, t2.field3, t2.field4...

zipped database

Hello i just tried Runningsum, the numbers are fine and i can order the data by the date, but now i cant join results in groups of 3 (i can only choose from query fields ). i need to group data in groups of 3, calculate average of those 3 results, while all the results together are sorted...

Hello i have a report based on query, where i have to join results in groups of 3 I cant sort the results in report according to date (ascending) although in the query everything seems fine - see pics I used a module for row numbers i found online but seems its too complicated for...

Hello sorry for late reply but now all works fine. Sum is working correctly and transfer to form is ok too, seems the field names with "č" were the problem. Thanks for all the help Best regards Jure

Hello First let me thank you for taking so much time with this project Regarding the language, having the Slovenian version of Windows, names of the fields with "č","š","ž" are not yet a problem. Nevertheless, i changed all the "naročila" fields to "narocila" (i sense some future problems...

No problem, its in the attachment

I tried to do that - i added an unbound field to form (named txtCena) now when i enter (or change) any of the product (dodatki) through subform combo all the txtCena in the subform change - i cant get different values (txtCena) for different products (IDdodatki) If i change a single product...

Hello I added another row in the source table of subform (tblPodrobNaroc), where the value txtCena is saved for each order. Now it works just fine, although now database has the same values in tbldodatki (CenaEnote) and tblpodrobnaroc (CenaEnote), i know that is not ideal - only ID fields...

Hello i have checked the combobox the way you recommended and i m getting the ID saved into the base table of subform (tblPodrobNaroc) I have a sample database where the Dlookup function is used in VBA as (cbododatki Afterupdate), should i do something like that: Dim strfilter as string...

yes i work with the ID, is that the reason?

Hello I have a problem with calculating sum of fields in the footer of subform The subform consists of following 5 fields Opis kolicina txtCena rabat CenaSpop Opis is combobox (cbododatki), which takes values from another table (tbldodatki) SELECT DISTINCT [IDdodatki]...

Hello My name is Jure and im from Slovenia, i occasionally work with databases, but with only basic knowledge i often get into difficulties. I recommend following slovenian book for learning Access to all fellow slovenian Access programers Popolni vodič Access 2003, Primož Bradač, Pasadena...