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!
Apropos of nothing, a few weeks back, I partially signed up for my free upgrade from XP Pro to Vista Pro. I only partially completed it in that I only ever filled out the info stuff on the web site. I never completed the second part -- which was to fill out a card and send it in with my receipt for my computer (something I didn't actually have).
I have received an email notification that my upgrade is whipping its way to me through the postal system.
I guess the two sides of that weren't connected.
Oh, I have no desire to actually switch, I'm perfectly happy with XP. I just want to have the upgrade CD in my possession.
Anyone do PHP PostgreSQL programming? I'm wondering if there's some sort of PGSQL equivalent to MySQL's mysql_insert_id function.
ita, see towards the bottom of this: [link]
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?
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
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?
Thanks! It is exactly what I wanted!
Oh- Except for the record source is (I think) an SQL statement that is SELECT DISTINCT ROW [Studentsandclasses]-- does that make a difference?