Search results

Genius. Thanks guys.

How would I go about subdividing that count further on the basis of other fields? Let's say I now want a three columns: month, number of records that are male, number of records that are female. I still do most of my queries in design view rather than SQL - which I've found to be very...

Much obliged. I have extended it to include years. Not sure what my mental block was on this one.

Hi All I would be grateful for some help solving a problem that seems so absurdly, insulting simple, that it shouldn't even be a problem at all. I have a date field in a table. I wish to display in a query: Column A representing the month. Column B representing the number of records in...

Thanks very much, hopefully that'll get me going. Lots of functions that aren't familiar to me there.

Hi All At present I have a tblData, a tblPeople, a long union query and a report that displays its results. On a form I select a person from tblPeople (another field on that table contains their email address), run the query and report in that person's respect and email the results to them...

Thanks Brian, and thanks again everyone for the advice.

In a new thread?

Thank you SOS that's cleared it all up. This is a marvellous place and you are wonderful people, I'm sorry to have been annoying and unfair in the course of my travails.

Thanks both of you.

My apologies Brian, the same question happened to arise from two distinct questions that did not belong in the same place. I was not aware when I asked my first two questions that the follow up question to both would be the same, and it seems to be just as rude of me to arbitrarily decide which...

Thank you, yes that does help. I suppose the thing I'm still a bit unclear on is how Access decides the format of the expression in the union query when some of the queries within that union query are generating a date format and some are generating text/string format. The report is...

Thank you SOS that's very helpful too.

Thanks again for your help, I would have been going round in circles for ages if you hadn't cleared that up. May I trouble you for one more piece of advice? I fear it's going to out me as a complete idiot at this stuff. Why does it matter in this scenario that the date format is a string when...

May I trouble you for one more bit of advice CJ? sorry if it's a completely stupid question... I just posted a thread on the "reports" bit of the forum in which, I am told, my schoolboy error was formatting dates using Format() not DateValue() - one returning a string, the other returning a...

That looks like a stroke of genius to me. Thanks, will try it later!

Thank you, I'll try that out when I get home. I sense frustration in your "..."s. My apologies, the hardest bit about learning access for me is working out when these different data types are actually important. As demonstrated above my report doesn't give a fig about thinking a date is text...

I want to be able to set text boxes so that if one enters a date and a time it displays in the format "dd/mm/yyyy hh:mm", but if one just enters a date is displays in the format "dd/mm/yyyy". Is this possible? Stipulating "dd/mm/yyyy hh:mm" means that when you just enter a date it adds "0"...

Hi All I wonder if anyone can shed some light on this maddeningly nonsensical facet of Access 2010? A few months ago I created a report that displays the results of a long union query comprising a dozen or so individual queries, each containing an expression that yields a date (or sometimes...

Setting the default value to blank means that there's nothing in the combo box when the form loads, I would like the combo box to tell me which record the form is currently displaying.