tdotsmiley
Last Activity: Oct 28 '06, 04:47 PM
Joined: Oct 20 '06
Location:
-
thats mmcarthy - that does the job :-)... -
- i tried both versions - with the empty string "" and with the isNull clause
- i added ( ) around my WHERE clause in both of the versions
- still returns one empty cell of NAME ......Leave a comment:
-
i tried:
...Code:SELECT Name FROM YoungAdults WHERE ([W1] & [W2] & [W3] & [W4] & [W5] & [W6] & [W7] & [W8] & [W9] Not Like "*08/*") And ([W1] & [W2] & [W3] & [W4] & [W5] & [W6] & [W7] & [W8] & [W9] Not Like "*09/*") And ([W1] & [W2] & [W3] & [W4] & [W5] & [W6] & [W7] & [W8] & [W9] Not Like "*10/*") And
Leave a comment:
-
one more catch .. lol
(just when you thought i would leave you all alone ;-))
how can i use null in line ([W1] & [W2] & [W3] & [W4] & [W5] & [W6] & [W7] & [W8] & [W9] = Null) - this does not work correctly - I want it to also display names which have no contents in them.
I have been able to succesfully get names to show for:
...Code:SELECT Name FROM YoungAdults
Leave a comment:
-
NeoPa - YOU ROCK!!!
Thanks so muchhh for the explanation! The code works beautifully! I'm amazed, and it is a whole lot shorter which makes it easier to follow!
Thank you again for all your help! :-)
Much Appreciated!...Leave a comment:
-
I get syntax error when I try to do the [].
Just another thought, when i do the following:
all the...Code:SELECT Name, W1, W2, W3, W4, W5, W6, W7 FROM Adults WHERE W1 Not Like "*09/*" OR W2 Not Like "*09/*" OR W3 Not Like "*09/*" OR W4 Not Like "*09/*" OR W5 Not Like "*09/*" OR W6 Not Like "*09/*" OR W7 Not Like "*09/*";
Leave a comment:
-
i tried to do this, so that i can make use of the like which i need - but it too is not working to remove all names which have month as 09
...Code:SELECT Name, W1, W2, W3, W4, W5, W6, W7 FROM Adults WHERE (Mid([W1],2,2)<>"*09/*" AND Mid([W2],2,2)<>"*09/*" AND Mid([W3],2,2)<>"*09/*" AND Mid([W4],2,2)<>"*09/*" AND Mid([W5],2,2)<>"*09/*"
Leave a comment:
-
it is not returning any records, when i know that in fact there are dozens which should be returned.
all that comes up are the column names, and one record of empty cells....Leave a comment:
-
killer42 - i meant to say that YOUR code worked for me.
mmccarthy's is still not working.
i have used the 09/ with LIKE in my very first query about showing just those in September, thats why that one works like a charm. but this one is still giving problems ......Leave a comment:
-
This code atleast generates a result. But another problem - I need to have the LIKE. The string in the field ie. T09/15 mean 09 - september and 15 - date .... if a name has D07/09 it also excludes this one - when in fact I just want to select ones that do not have September (09) ... therefore, I would have a whole lot more results....Leave a comment:
-
nope, this one actually does what i want it too ... let me try the other stuff you all have posted, i shall be bak with a reply to the others...Leave a comment:
-
oh ya, and i got an easier way (or so it looks simpler) to select those with '09':
SELECT Adults.NAME, W1
FROM Adults
WHERE (((Adults.W1) Like '*09/*'))
UNION
SELECT Adults.NAME, W2
FROM Adults
WHERE (((Adults.W2) Like '*09/*'))
UNION
SELECT Adults.NAME, W3
FROM Adults
WHERE (((Adults.W3) Like '*09/*'))
UNION
SELECT Adults.NAME,...Leave a comment:
-
ok, this is giving me an error that the SELECT statement contains a word that is mis-spelled or punctutation is incorrect....Leave a comment:
-
ya, i'm not that great at access - just know the basics. hopefully mccarthy can provide some insight!...Leave a comment:
-
yup, i am 100% sure that there are multiple records which do not have 09 anywhere.
i don't know what else to try, you all have been of great help, but nothing seems to be able to execute the result i need :S...Leave a comment:
-
Multiple Union Queries + Showing the results in One Report/Form
Hi,
I have multiple union queries that I have. These are from 4 different tables.
Is there a way I can use the report feature so that it combines all of the queries into one file so that I can print it as one page rather than 4?
thanks -
yes, i did try the above code - basically what comes up are just the column names - no data is shown in the cells....Leave a comment:
-
when i execute this query i get the error that the specified expression IIf ... is not part of an aggregate function.
with this query i want to be able to select NAMES of people who do not have 09 in any of the W1 - W7 columns. basically, now i want to result the opposite of what was first done - selecting those that have 09.
i tried doing the simple opposite of using NOT LIKE, but that does not work.
...Leave a comment:
-
that still does not perform the correct query :S...Leave a comment:
-
still doesnt give me the output i need. it removes the first name which does not have 09 in it, but then the rest are still there.
what this query is doing is removing the 09 date from the column and displaying all the names.
what i need it to do is to remove the name (with the record) of people who have 09 anywhere in their record
thanks a lotLeave a comment:
No activity results to display
Leave a comment: