Recent content by Squidinker

Just a quick reply DarkAngel - it's not exactly what you need but I don't quite have the time at the moment to tailor it for you. It should be the right avenue though. The following is from Wazz in reply a thread of mine earlier, so credit to him of course: This would be a VB routine but...

Thanks for the reply Wazz - worst case, then two queries will work (I hadn't really considered that). To be honest, I haven't given alternative solutions much thought since I felt the solution would be exceedingly simple. After all, all I want is to use a checkbox to alternate between and empty...

I'm not sure I see how that is going to help. I don't want to use Is Null or IsNull as an expression; I only want it returned if a given condition is met (the form tickbox is checked). IsNull returns a true or false where all I want to do is to filter out those records that are NOT Null. What I...

Thanks a lot for the help guys... However I think I did a pretty poor job explaining what I am trying to do. I have a query that pulls from several tables. The result of this table is used in a subform as a list of items which primarily will be used for visual analysis. One of the fields...

Dan, why not just Right Align the whole column then use indent?

Hi, Should be a very quick question for someone with more experience than me (i.e. everyone on here): What is the correct syntax in an IIf function that allows "Is Null" to be the criteria if the logic is met? I have an IIf statement as a field's criteria in a query and one of the results of...

Comparison should help. Open up a fast profile and press CTRL+ALT+DEL and bring up task manager. Switch to the Processes tab an note how many processes are running, how much memory they use and whether they are taxing the processor(s). Best way is to just print screen the whole list. Then...

Hmm, that is the question... you can put the formula in another sheet easily - you just have to make sure that you reference the cells in the specified sheet properly; instead of K2 you need Sheet1!K2 where Sheet1! is the name of the sheet with a "!" at the end to denote the reference...

Argh, please disregard. =IF(AND((H2>0),(H1<0))=TRUE,D2,"") ^^ much better. Single column, much cleaner. It simply says what we want; IF the proceeding cell is negative AND the preceding cell is positive (then) show cell D2 (or whatever cell you want) (otherwise) print nothing.

The error is probably coming from my just cutting and pasting the formula from my xls - it is likely looking for a cell in a sheet that is not there. The second column "Highlight?" is simply there to break the process down. It doesn't bring up a value but highlights if it is one that you are...

Hey Razor, I'm not 100% sure I have absolutely, completely and unequivocally understood what you need but (and with those caveats over with), please have a look at the attached xls (it was made in 2k7 btw so I hope the functionality is still in there). As I understand, you need to save values...