This was the final outcome.
And as text for anyone.
Performance: Sum(IIf([Written Business]![Solution-Date_of_Sale] Between [From] And [To] And Nz([Written Business]![Solution Area]=[Solution-Area-Target],"*") And Nz([Written Business]![Product Category]=[Product-Category-Target],"*") And...
Okay people i have managed to figure it out on my own it was just as simple as setting the criteria for the NZ([Expression],"*").
I hope this helps someone else in the future.
Hi All,
I have a bit of a headache in trying to figure out what i need to do with this query to get the outcome that i want so i hope you lot can help me out.
I have a query for where i am using the expression builder to set my iif criteria, The expression builder will be referencing another...
Thank you for the reply, i figured i would need to do something like that
Thank you for this i believe this is something that i am looking for. I will study this now and try and get it working in my scenario.
Many Thanks
Hello All,
I am at a loss on this one and i just need someone to point me in the right direction and i apologise if there is a thread for this somewhere I'm just not sure of the right function i should be looking for to do what i want.
I have a Navigation Form which has several tabs which have...
The idea for the function is not for the main use of the system.
I have a form that displays an attachment image which would be things like offers an promotions to keep the members informed of whats going on.
I am using traditional wizard commands to navigate through the different promotions...
Am just thinking on an idea to help streamline a part of our system so it's more user friendly.
Do you have any idea on what the vba would have to be like in order to do this?
Is it possible when using the go to next record wizard to program it up when it reaches the end record I.e a null record that it resets itself and starts over again so it's on a loop?
Great that works but i ran into a snag which am now not sure what's best way to handle it. I may need to have a think on the best way to deal with this new problem.
Long story short, when the duplicate function kicks in an creates a new record there is a set field which looks at what has been...
Hello i wonder if someone can help me as i cant seem to find an answer any where to what i need.
I have a form where a user can input data into it. I have a duplicate record function for where the user can duplicate the record as many time as they want, however when they are wanting to...
Yes the table has a Primary Key field, I am just struggling to see how an Append Query will work in this situation that i am trying to do.
Is there some code i can use to run the APPEND Query from VBA?
Sorry but when it comes to VBA & APPEND Queries am learning as i go along.
Okay very interesting here when i set the focus i get a new problem.
I get the following;
Run-time error '2226':
The Clipboard isn't responding, so Access Database can't paste the Clipboard's contents.
Any ideas?