Go Back   Access World Forums > Search Forums

 
Showing results 1 to 11 of 11
Search took 0.01 seconds.
Search: Posts Made By: Squidinker
Forum: Queries 07-05-2007, 08:28 AM
Replies: 5
Views: 864
Posted By Squidinker
Just a quick reply DarkAngel - it's not exactly...

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...
Forum: Queries 07-04-2007, 12:04 PM
Replies: 7
Views: 792
Posted By Squidinker
Thanks for the reply Wazz - worst case, then two...

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...
Forum: Queries 07-04-2007, 10:21 AM
Replies: 7
Views: 792
Posted By Squidinker
I'm not sure I see how that is going to help. I...

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...
Forum: Queries 07-04-2007, 03:07 AM
Replies: 7
Views: 792
Posted By Squidinker
Thanks a lot for the help guys... However 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...
Forum: Excel 07-03-2007, 01:10 PM
Replies: 6
Views: 1,774
Posted By Squidinker
Dan, why not just Right Align the whole column...

Dan, why not just Right Align the whole column then use indent?
Forum: Queries 07-03-2007, 12:49 PM
Replies: 7
Views: 792
Posted By Squidinker
Criteria syntax problem

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...
Forum: Windows 06-29-2007, 06:39 AM
Replies: 3
Views: 1,378
Posted By Squidinker
Comparison should help. Open up a fast profile...

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...
Forum: Excel 06-29-2007, 03:24 AM
Replies: 17
Views: 2,081
Posted By Squidinker
Hmm, that is the question... you can put the...

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...
Forum: Excel 06-28-2007, 04:03 PM
Replies: 17
Views: 2,081
Posted By Squidinker
Argh, please disregard. ...

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...
Forum: Excel 06-28-2007, 04:00 PM
Replies: 17
Views: 2,081
Posted By Squidinker
The error is probably coming from my just cutting...

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...
Forum: Excel 06-28-2007, 09:20 AM
Replies: 17
Views: 2,081
Posted By Squidinker
Hey Razor, I'm not 100% sure I have...

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...
Showing results 1 to 11 of 11

 
Forum Jump



All times are GMT -8. The time now is 10:47 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World