Search results

Please kindly advise on how to possibly re-link an accdr front end database file (has navigation form on it) to accdb backend database file from a computer in runtime environtment as it has no full Access installed. Thank you.

Generally speaking, can we create one field in our query which contain autogenerated id number start from #1 from first row (that correspond to sorting and filtering results of some fields from a table)?

as the table grows up, how if i want to accomodate date of period in the query as i entered this >=[Enter the Start Date] And <=[End Date] in the criteria in design view, tried but get incorrect running sum result (cjlondon version) and run-time 3061 (arnelgp version)

Thank you CJ for the link, will look through it; btw i'm using office365.

Duly noted CJ for the explanation; i will test thoroughly yours and Arnels working solution with real data in sufficient numbers and report here. By the way can suggest me with the thread link on simple example in how to use the RunningSum in the report? Thank you all friends who have helped me...

Oh sorry i didn't check it there, now working as great charm, thank you so much Arnelgp.

Yes I have tested changing the sorting order specified on the right and noted now working with ascending-ascending order (when using <) and descending-descending order (when using >), any possibility to sort in ascending-descending or descending-ascending order as these combination still...

Great Arnelgp, it works as supposed to be; here I want to copy the modified Query1 to accommodate another event with just using one created module (here you created and named as Module1), so every event will have its own query, is it possible to do that way? When I just rename the query from...

Thank you CJ, the code is now running with ascending order; to have it programmed and run correctly by selecting the sorting method in ascending or descending combination order from the Design View seems to be very challenging so far.

ID_Invoice is autonumber generated by Access everytime a record is entered into the database, in one invoice there is a big possibility to have 5 items listed so it means 5 records will be entered; suppose i entered bunch of invoice papers where in unsorted date condition, so i can just started...

When I try to run in ascending order it also still fail

I run both of the code and highlighted the query as runningtotal not giving the correct total at the end.

Thank you for your feedback, how for the ascending/descending sort in Invoice_Date and ID_Invoice, and also event criteria, can just set it in designview or must accomodate it in the sql code?

Thank you Arnelgp, I have tested with every event, it will fail for any descending sort combination in Invoice_Date and ID_Invoice, but I'm sure it is almost there, kindly see my attached screenshots using PARTY event selected.

Have tried also the following code but still unsuccessful : SELECT mainQ.Event, mainQ.Invoice_Date, mainQ.ID_Invoice, mainQ.Quantity, mainQ.Unit_Price, (SELECT SUM(Quantity*Unit_Price) FROM Table_Invoice WHERE mainQ.Event>= Table_Invoice.Event AND mainQ.Invoice_Date >=...

Have included both in the SQL Code with no luck, screenshoots as attached

Thank you Plog, i tried to select based on event inherited from your code, unfortunately still not giving correct runningsum amount (please see the attached files for screenshots and database files).

If I add TOTAL as a calculated field in Table_Invoice, will it simplify the case as the total number will be called from the table (not calculated in the same query with running sum field)?

Thank you for the SQL code Plog, unfortunately I got syntax error popup message when putting the code (screenshots as attached).

Hello June7 and Plog, highly appreciated for your reply; OFFICE and PARTY values are just such event category to organize the product, both using Short Text Data Type