Search results

Thanks all - figured it out with the last one from Ranman. Set my criteria and where, then count the number of ref's. Thanks

Hi, I've tried adding totals and selecting 'Count' on the status field (which has a criteria of 'open'). I get an error 'You tried to execute a query that does not include the specified expression 'Ref' as part of an aggregate function'. What am i doing wrong? Thanks

Thanks for the reply. The SQL (though I'm not good at reading it) looks like this for my existing query What I want ideally is a way within the report/query to show how many records are owned by bob, jane or freddy. If there is a better way of doing it am more than happy to try, but creating...

Hi, Within my database each record is owned by at least one staff member (I have a field called owner). For a report I want to be able to provide a summary to say staff member 'x' owns 'y' records, staff member 'a' owns 'b' records, etc. There are only 5 possible staff members so I'm happy...

Mr Smartypants? Not my given name to be honest... but hey thanks I do try to learn new things when I can. I'm surprised you are MVP not because of your knowledge but because of your public approach - wonder if MS check to see how their MVP's approach members of the public? They certainly...

'The main form of the main table is configured such as to let me select multiple values from a combo box from the tblkeyword table, all working fine.' If you know combo boxes/list boxes. How come you'd not heard of the changes in Access 2007? Is it because your arrogance is larger than your...

So why strong worded? you don't know me. My question was not a stupid one. If you don't have access 2007 and can't help then don't answer the the first place. All you've managed to do is make yourself look a like a rude, ignorant prick

1) your posts have been unhelpful and quite pointed (rude). Which are hardly inviting to new forum members!! 2) the webpage makes it clear that the control is a combobox. It may be an ms 'fudge' but 'When you click the combo box, check boxes appear selected to indicate your choices. You can...

http://office.microsoft.com/en-us/access/HA012337221033.aspx ' When you click the combo box, check boxes appear selected to indicate your choices. You can check or uncheck items in the list and then click OK to submit your choices. '

Hi, I've a Access 2007 database which I want to use a field keywords with. The keywords field in my main table is a look up field to another table (called tblkeyword) containing a list of words. The main form of the main table is configured such as to let me select multiple values from a...