Recent content by accessAnswer

Hey, I think the proposed a good solution in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=99191 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ visit msaccess2010.com - tutorials, bugs, fixes,errors and q & a

Great! Good luck!

Sorry, I if you are in Design View of Query : 1st column: LeaseCost: IIf([tblCompanies].[Portfolio]=0,Sum(([DailyRate]*[workingdays])),0) 2nd column: PreDiscount: Sum(LeaseCost) The query would first evaluate LeaseCost, and next go on to Taking value in LeaseCost column ( number) and...

have you tried : (Sum(IIf([tblCompanies].[Portfolio]=0,(Sum([DailyRate]*[workingdays])),0))) as LeaseCost, Sum([LeaseCost])

This means that you have 324 unique lines ( that means you have this many unique lines with date in the past ( or today). Just test it. a) take lines that exist before the query b) see if they are deleted by query Do you want that to happen? see what is wrong Check if your Date()...

1. To Avoid Warnings, If you put your query in a Macro and before OpenQuery, you put Action: SetWarnings, Warning On: NO 2. Maybe you can change query to not use that form parameter. Since if that form not open, it means you do not need that forms parameter really. That forms parameter should...

hmmm. Union- not just deletes duplicates in the second query, but in general it combines 2 queries and then from the final result it deletes all duplicate lines. You can put: Select * from Query 1 Where Fabricate<=Date() Union Select * from Query 2 Where Fabricate<=Date();

Great! It works! Magic In addition i see in my result, we have to do Final GROUPING in case Event 123 has : Action 2 - Priority 3 Action 3 - priority 3 Other than that Great Query

To Combine 2 queries together use Select * from Query 1 Union Select * from Query 2 ; "Union" would delete for you rows in Query 2 that are duplicated in Query 1.

Hey Jereece, From what I understood, this solution below should work: So here is your solution: Query 0: If the same Event_No has many diff Action_No with same priority- Group Then together: The below becomes 1 line: SELECT DiSTINCT Practice.Event_no, Practice.Priority FROM...

hey, So if I understood you correctly, You need a such a query that if you run it on this table: Site Event_No Action_No Priority 1 123 1 2 1 123 2 3 1 123 3 3 1 123 4 2 1 123 5 1 The result would be empty. Since This table only has Event_no =123 ( only 1 event) and this Event has...

Wow, So it was in in .mda created library. Interesting. Great that you figured it out! All the best!

Hey, Ok. Can you try to run in VBA immediate Window: for each r in references : debug.Print r.name, r.fullpath : next r Lets us know what libraries show up: Standard thing is : C:\Program Files\Common Files\Microsoft Shared\vba\vba6\vbe6.dll C:\Program Files\Microsoft...

Hello, You can put all your queries in the Macro. You do not need to know VBA. in Panel , Select Insert--> Macro and then Fill in the Macro: Add New Action --> Open OpenQuery Enter Query Name Then Add another Action --> Open Query ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ visit...

you might be missing a reference ( library) or have a broken reference to the library that has format function. Enter ?Format(Date(), "mm/'dd/yyyy") in the Immediate window does it work or do you get an error? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ visit msaccess2010.com ............for...