ita, see towards the bottom of this: [link]
Well, we may not have parted on the best of terms. I realize certain words were exchanged. Also, certain... bullets. But that's air through the engine. It's past. We're business people.
Mal ,'Serenity'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Kevin - Apr 02, 2007 11:17:23 pm PDT #1124 of 25496
Never fall in love with somebody you actually love.
§ ita § - Apr 03, 2007 4:12:06 am PDT #1125 of 25496
Well not canonically, no, but this is transformative fiction.
I'm not sure I ever tested the equivalent on MySQL, but when I thought of retrieving the last serial # in PGSQL it seemed easy enough to get the last serial # but of someone else's more recent transaction. Maybe a stored procedure?
Sophia Brooks - Apr 03, 2007 4:44:07 am PDT #1126 of 25496
Cats to become a rabbit should gather immediately now here
I have a quick Access question. I have a subform with a field that counts the number of records with =Count(*). What I would like to do is exclude some people from that count, ones who have a 'Yes' in the the field "Cancelled". Is this possible easily? (If it isn't, I don't need anyone to spend a lot of time on it)
THanks
tommyrot - Apr 03, 2007 4:50:56 am PDT #1127 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
I have a quick Access question. I have a subform with a field that counts the number of records with =Count(*). What I would like to do is exclude some people from that count, ones who have a 'Yes' in the the field "Cancelled". Is this possible easily? (If it isn't, I don't need anyone to spend a lot of time on it)
Yeah, it's simple. Say the subform has the recordsource "myQuery", then you could use the DCount like this:
=dCount("*","myQuery","Cancelled=Yes")
Assuming Cancelled is a binary field. If it's a text field, put the 'Yes' inside single quotes.
Is that what you wanted?
Sophia Brooks - Apr 03, 2007 4:52:31 am PDT #1128 of 25496
Cats to become a rabbit should gather immediately now here
Thanks! It is exactly what I wanted!
Sophia Brooks - Apr 03, 2007 5:03:11 am PDT #1129 of 25496
Cats to become a rabbit should gather immediately now here
Oh- Except for the record source is (I think) an SQL statement that is SELECT DISTINCT ROW [Studentsandclasses]-- does that make a difference?
tommyrot - Apr 03, 2007 5:04:54 am PDT #1130 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
No. Just put the SQL statement inside the quotes where the query/table name would otherwise go.
Sophia Brooks - Apr 03, 2007 5:06:28 am PDT #1131 of 25496
Cats to become a rabbit should gather immediately now here
Thanks!
flea - Apr 03, 2007 5:27:58 am PDT #1132 of 25496
information libertarian
Just as an aside, every time is see "mySQL" my brain goes "My So-Called Life."
Jessica - Apr 03, 2007 9:02:15 am PDT #1133 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Sheep that I am, I just signed up for a Twitter account. Anyone have one of these and actually use it?