Search results for query: *

you're right. in hindsight, i realized that i entered not like 2005 on one line and is null and the other line. which seems to be why it excluded all the other records that fit the 'is null' criteria. thanks.

anyway, since i didn't want to try the 'if' idea, i would have to dig up my access book for that, i figured out another way. i typed NOT LIKE '2005' OR IS NULL. it's the only way i could make it work. thanks everyone. Heidi.

i've tried all of your suggestions(before i posted my message). the problem is that if i put in 'not in 2005' and is null, it filters all the records that have something other than 2005 in memo. as for mzkitty's suggestions, i'm not so familiar with slq, perhaps you can write it out, i'm not...

i'm trying to create the following query: from donation records i want all those records that have t05 in the donation type but not those that have '2005' in the memo field. now, if i type 'not like 2005' in the criteria for memo and t05 for the donation type field, i only get those fields that...

i'm looking to buy a portable dvd player, and in most of the specs it says that it's compatible with dvd-r discs for video and cd-r only for audio. i have many files in avi format which i would like to watch on the player. is there any way to burn it on cd (i don't have a dvd burner) so that it...

i tried to create a month group level, but the total amount i get, per month, is not correct. instead of getting the total for the month, i get the total for the day (in the query, i used the aggregate function SUM). this is what i get: january - 1500 (total for jan 5) february - 1700 (total...

i have the following query which gives me the total donations for all clients for a given time period, say, a year. (not for profit charitable organization). SELECT PaymentTable.date, DonorTable.donor_title, DonorTable.donor_f_name, DonorTable.donor_l_name, Donations.donation_type...

thanks y'all! the first one =b1*(1+a1) works! it's a beautiful thing.

that's good. but since i want to use if more than once, and for clarity purposes, i have field a1 that says 5% and field b1 that says 20,500. in a new field i type a1+b1 and instead of getting 21,525.00, the computer treats my 5% as .05 and gives me a total of 20,500.05. the reason i'm using +...

can someone tell me how to write the following formula a1+b1 * 5% + (a1+b1*5%)* 4% + (a1+b1*5%*4%)*3.6% etc. i'm trying to get a total that contains several percentage increases ONE ON TOP OF THE OTHER (piggyback) please help

i don't think it's worth the hassle. isn't it easier to just get a usb mouse?

it's an hp mouse, i don't know the model number and i'm running windows 2000. but i must tell you that i had the same problem with another mouse that i tried (a logitech) AND when i was using win xp on the same computer

i have a similar problem. my cd burner/dvd drive (from lg running on win xp) will read blank cd's as well as audio cd's (only those with NO DAMAGE whatsoever) and data cd's no problem. but it will not read any game cd's i.e. scrabble, boggle etc. (it pretends nothing is in there)or audio cd's...

i already posted this problem once, but i have not yet resolved the issue. i am running windows 2000, and very often when i reboot (say 7 out of 10 times) the computer does not recognize the mouse; i have to reboot again, sometimes as many as 10 times until the computer "finds" the mouse. some...

I have a cd writer/dvd player from LG. It will play audio cd's as well as video cd's, and dvd's. burning cd's is not a problem either. but it won't recognize cd-roms. I've tried running several "game cd's" and the sytem acts like there is a blank cd in the drive. any ideas?

the mouse i'm using is ps/2 (the round one) and the brand is hewlett packard. i did mention that this happened with another mouse that i tried, actually two others, both of them generic. re Jowers' post: what does it mean a fault in the port? and what can be done about it. should i try using a...

i am running windows 2000 on my computer and i'm encountering this very weird problem. when i boot, the computer won't recognize my mouse. it can take as many as TWENTY reboots and sometimes only a few, and then it does recognize it and everything's dandy UNTiL...the next time i need to reboot...

all of your suggestions sound plausible, and I thank you for taking the time to address my problem. I had almost discounted the shabby quality of the cd as being the cause of the problem, when i realized that I used to use Sony cd's, and never had a problem, and recently ( over a while, granted...

i have a cd/dvd drive for about a year now, never had a problem. it's an LG. lately, i have trouble burning my rewritable cd's. i've been using memorex rewritables, and i even bought brand new ones, i thought age was the problem. after i finish burning a video file, replay is very jerky and...