A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 66
Search took 0.26 seconds.
Search: Posts made by: hannah
Forum: Worksheet Functions March 25th, 2010, 10:21 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 86
Posted By hannah
IF - more than seven arguments

Brilliant - thank you!

"Jacob Skaria" wrote:

With date in cell A1 try
=TEXT(A1,"mmmm")

=TEXT(A1,"mmm")

--
Forum: Worksheet Functions March 25th, 2010, 10:00 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 86
Posted By hannah
IF - more than seven arguments

Good morning

I would like to write an if formula that will provide me with the month (in
words) if the date in a column falls between certain values, this needs to be
ongoing as the spreadsheet...
Forum: Worksheet Functions March 24th, 2010, 05:11 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 100
Posted By hannah
Sumproduct?

Good Afternoon

Please could someone help....

I have a monster spreadsheet that tracks recruitment numbers and as part of
our monthly reporting i need to count various monthly stats

The...
Forum: Database Design November 18th, 2009, 10:19 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 13
Views: 259
Posted By hannah
Table design help!

Thanks Fred - you've given me a lot to think about and I'm feeling much more
happy about approaching it. Thanks again, can't tell you how much I
appreciate it.

"Fred" wrote:

Hannah,

Great...
Forum: New Users November 18th, 2009, 10:08 AM Posted to microsoft.public.access.gettingstarted
Replies: 6
Views: 97
Posted By hannah
Design questions

Sorry about that Karl - 'sheet' was my bad choice of words (I meant sheet as
in paper sheet!). Thanks for all your help - you've given me heaps to think
about and get working on!

"KARL DEWEY"...
Forum: New Users November 17th, 2009, 11:13 AM Posted to microsoft.public.access.gettingstarted
Replies: 6
Views: 97
Posted By hannah
Design questions

Just trying to put your suggestions into practice and have immediately
realised I explained myself very badly about monitoring.

Each monitoring sheet has several different categories (plastics,...
Forum: Database Design November 17th, 2009, 11:02 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 13
Views: 259
Posted By hannah
Table design help!

Fred - first off thank you for being so patient with me! I really do
appreciate all your help. In answer to your questions:

1. It's a bit difficult because I have so many different types of...
Forum: New Users November 17th, 2009, 10:43 AM Posted to microsoft.public.access.gettingstarted
Replies: 6
Views: 97
Posted By hannah
Design questions

Thank you for your help - that's straightened out quite a few things for me!
I think my obsession with tables, tables, lots of tables comes from some
training I had a few weeks back but I can see...
Forum: New Users November 16th, 2009, 06:11 PM Posted to microsoft.public.access.gettingstarted
Replies: 6
Views: 97
Posted By hannah
Design questions

I am extremely new (and pretty much entirely self-taught) to Access and think
I should give some background to my questions. I'm currently working on a
database (separate to the one I've posted...
Forum: Database Design November 16th, 2009, 04:07 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 13
Views: 259
Posted By hannah
Table design help!

Hello Fred,
Your honesty is very much appreciated - every bit of advice is really useful
and I dread to think where I'd be without the amazingly helpful people in
this group.

In response to your...
Forum: Database Design November 16th, 2009, 10:56 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 13
Views: 259
Posted By hannah
Table design help!

Thanks for your in put and apologies for my lousy explanation! You are right
Fred in that I don't feel particularly clear on the fundamentals of what I'm
doing really at all. And thanks Jeff for...
Forum: Worksheet Functions November 16th, 2009, 10:31 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 46
Posted By hannah
Count if?

Thank you - thta's brilliant!

"Pete_UK" wrote:

To count values in column A not equal to 15, for example:

=COUNTIF(A:A,"15")

Hope this helps.
Forum: Using Forms November 16th, 2009, 10:28 AM Posted to microsoft.public.access.forms
Replies: 2
Views: 117
Posted By hannah
Combo box Subform Control Default

Thanks Jeanette. I've got it working now and it looks so much better. Thanks
ever so much again!

Hannah

"Jeanette Cunningham" wrote:

Hi Hannah,
here is a way to set the combo box to show the...
Forum: Worksheet Functions November 13th, 2009, 04:13 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 46
Posted By hannah
Count if?

Good afternoon

Please could you tell me if there is any way to count all the cells that are
not equal to a value or to count all those cells that contain text?

Many thanks

Hannah
Forum: Using Forms November 13th, 2009, 03:20 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 117
Posted By hannah
Combo box Subform Control Default

Apologies if this is here already - I can't seem to find it and I'm seriously
stumped about how I do it.

I'm working on a main form which has a combo box and a subform control.
Depending on the...
Forum: Database Design November 13th, 2009, 01:26 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 13
Views: 259
Posted By hannah
Table design help!

P.S. what I totally forgot to say was whether it's okay to have a table with
just one field (e.g. just "do you eat cheese?" tick box)? Want to make sure
I'm doing this right from the...
Forum: Database Design November 13th, 2009, 01:24 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 13
Views: 259
Posted By hannah
Table design help!

I'm a bit of an access novice (training on basics, searching for help on the
rest) building a database for a research project. I've tried having a wee
look for this question but I can't spot it...
Forum: Worksheet Functions November 13th, 2009, 10:11 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 67
Posted By hannah
Concatenate and IF?

Good Morning

Many thanks for your assistance.

The list formula is great, but i'm not sure how to adapt it so that it works
in my spreadsheet as i have two columns for each month (and i'm looking...
Forum: Worksheet Functions November 12th, 2009, 05:32 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 67
Posted By hannah
Concatenate and IF?

Good Afternoon

I have an excel spreadsheet which shows all the active vacancies for each
department.

December January
Detail (inc date) Forecast Detail (inc date) Forecast
Engineering Portfolio...
Forum: General Discussion November 12th, 2009, 11:11 AM Posted to microsoft.public.access
Replies: 3
Views: 59
Posted By hannah
Broken query/relationship

Hi Jerry,
You were right! Working with it a bit more, I understand that Option 2 is by
best plan - thank you ever so much! The problem I now have is to make my
query display records from each of my...
Forum: General Discussion November 11th, 2009, 05:15 PM Posted to microsoft.public.access
Replies: 3
Views: 59
Posted By hannah
Broken query/relationship

Thanks for such a quick reply! I had a go at what you suggested and it does
mean that records show up now in the query but not really in the way I want.
Option 1 is really what I need so I'll try...
Forum: General Discussion November 11th, 2009, 03:41 PM Posted to microsoft.public.access
Replies: 3
Views: 59
Posted By hannah
Broken query/relationship

I've had a hunt around and couldn't find an answer to this particular query
but I'm really sorry if it's on here somewhere already!

I'm setting up a database to store and analyse questionnaire...
Forum: General Discussion November 10th, 2009, 10:10 AM Posted to microsoft.public.access
Replies: 1
Views: 53
Posted By hannah
Research Project: one database or seperate

I'm a bit of an access novice and have a wee question. I'm building a
database to store and analyse questionnaire responses for a research project.
I have 11 separate questionnaires for different...
Forum: New Users November 8th, 2009, 11:35 PM Posted to microsoft.public.access.gettingstarted
Replies: 1
Views: 86
Posted By hannah
Research project: one database or several

I'm a bit of an Access novice and, although I've had a wee root around these
posts, I apologise if the answer to my question is already there somewhere.

I'm working on a database to hold and help...
Forum: General Discussion November 8th, 2009, 11:12 PM Posted to microsoft.public.access
Replies: 6
Views: 58
Posted By hannah
Research project: one database or several

I'm a bit of an access novice and I've had a wee search around these posts
but I apologise if my question has already been covered elsewhere.

I'm trying to build a database to hold questionnaire...
Showing results 1 to 25 of 66

 
Forum Jump

All times are GMT +1. The time now is 05:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.