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 67
Search took 1.19 seconds.
Search: Posts made by: cinnie
Forum: Database Design May 30th, 2010, 01:32 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 8
Views: 775
Posted By cinnie
Allen Browne's 'Library Resource'

Fred - that's a nice resource! I'm studying the relationships between your
tables and picking up some good tips. That's an area I need to improve in.

Thank you
--
cinnie


"Fred Boer" wrote:
Forum: Database Design May 30th, 2010, 01:29 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 8
Views: 775
Posted By cinnie
Allen Browne's 'Library Resource'

Thanks Allen

My interest wasn't in designing a Library database per se, but I was
interested in some of the subtler issues you dealt with in the table design.
(the fact that it dealt with library...
Forum: Database Design May 28th, 2010, 07:43 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 8
Views: 775
Posted By cinnie
Allen Browne's 'Library Resource'

hello gurus

I have learned a lot by studying the 'Library resource' example on Allen
Browne's web site. This offers a lot of good advice on the organization of
tables for a Library database. Is...
Forum: Setting Up & Running Reports April 30th, 2010, 01:24 AM Posted to microsoft.public.access.reports
Replies: 1
Views: 510
Posted By cinnie
positioning a subreport

hello
I have a subreport in my main report's Page Footer. The subreport shows a
single column with from 1 to 5 rows. The subreport has a solid hairline
border that can grow. I want the bottom of...
Forum: Setting Up & Running Reports April 26th, 2010, 01:42 PM Posted to microsoft.public.access.reports
Replies: 1
Views: 186
Posted By cinnie
Report Column questions

hi to all - I have 2 questions re columns in reports (hope that's OK)

a) I'd like to have 2 columns in the Detail section of my report, but only
one column in one of my Group Header sections. Is...
Forum: Running & Setting Up Queries April 11th, 2010, 03:08 AM Posted to microsoft.public.access.queries
Replies: 1
Views: 86
Posted By cinnie
CrossTab Query question

hello to all

I have a Report that is based on two crosstab queries, qryA and qryB (shown
below). Because these both have exactly the same Row Headings and exactly
corresponding records. They...
Forum: Running & Setting Up Queries March 22nd, 2010, 04:41 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 271
Posted By cinnie
an ALIAS question?

thanks to Marshall and Duane for some solid advice - cinnie
--
cinnie


"Marshall Barton" wrote:

cinnie wrote:
I have a Report based on the Cross Tab query shown below:
Forum: Running & Setting Up Queries March 21st, 2010, 08:50 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 271
Posted By cinnie
an ALIAS question?

hello gurus

I have a Report based on the Cross Tab query shown below:

TRANSFORM Count(qryEmp.SiteID) AS CountOfSiteID
SELECT qryEmp.SiteName, Count(qryEmp.SiteID) AS [Site Count]
FROM qryEmp
...
Forum: Setting Up & Running Reports March 20th, 2010, 11:39 PM Posted to microsoft.public.access.reports
Replies: 7
Views: 145
Posted By cinnie
Summing a column in a report

Yes, that was it! What I had already done was consistent with the good
advice from all of the experts that replied. But still nothing worked. You
identified the key point - that the numbers...
Forum: Setting Up & Running Reports March 20th, 2010, 02:56 PM Posted to microsoft.public.access.reports
Replies: 7
Views: 145
Posted By cinnie
Summing a column in a report

thanks Al and John. I think the reason Control Source: = Sum([txtA])
doesn't work is that txtA is from a XTab query. It is calculated based on a
Count. Does that mean I can't use 'Sum([txtA])'...
Forum: Setting Up & Running Reports March 20th, 2010, 01:37 PM Posted to microsoft.public.access.reports
Replies: 7
Views: 145
Posted By cinnie
Summing a column in a report

My report has a column of numbers. Below the column, I would like to show a
text box with the sum of these numbers. In Excel I would just use something
like "= Sum(C3:C56)", but I don't know how...
Forum: Worksheet Functions March 19th, 2010, 06:08 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 108
Posted By cinnie
a Counting question

Thanks teethless mama - that what I needed
--
cinnie


"Teethless mama" wrote:

=COUNTIF(B5:B1525,"="&A3)

Forum: Worksheet Functions March 19th, 2010, 01:00 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 108
Posted By cinnie
a Counting question

hi to all

I'm sure this is easy, but I'm new to Excel.
I need a function that will COUNT all the numbers in a range (B5:B1525)
equal to or greater than the value in A3. (all values are positive...
Forum: Running & Setting Up Queries March 11th, 2010, 05:06 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 167
Posted By cinnie
SQL question - Cross Tab query

hello gurus

I have a Cross Tab query that works fine. The SQL for this query ends with...

PIVOT tblData.Region

I've noticed that the column headings in my query result always show the
Regions...
Forum: New Users March 4th, 2010, 11:28 PM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 179
Posted By cinnie
Insert Comments on a Protected Worksheet

hi - I have a worksheet with areas that are locked, and a range B5:H23 that
is not locked. Protection has been applied to the sheet. The user is
allowed to SELECT unlocked cells.

My problem is...
Forum: Worksheet Functions March 4th, 2010, 04:22 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 88
Posted By cinnie
Function help requested please

Thanks to Fred, Mike, Ron and NSNR. These different appraoches work GREAT!
--
cinnie


"Ron Rosenfeld" wrote:

On Thu, 4 Mar 2010 06:06:02 -0800, cinnie
...
Forum: Worksheet Functions March 4th, 2010, 02:06 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 6
Views: 88
Posted By cinnie
Function help requested please

Hello to all

I have worked with functions in other programs, but I am totally new to
Excel. Here's my situation - I have a table like the following that extends
for 10 rows.

A B...
Forum: Running & Setting Up Queries February 14th, 2010, 11:30 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 197
Posted By cinnie
SQL help needed please

In both cases, I changed "WHERE TableC.CustID is Not Null"
to "WHERE TableC.CustID is Null".
--
cinnie


"John Spencer" wrote:

If you have links in the A.mdb to the relevant table in B.Mdb and...
Forum: Running & Setting Up Queries February 13th, 2010, 07:40 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 197
Posted By cinnie
SQL help needed please

That does it! Thanks.
--
cinnie


"John Spencer" wrote:

If you have links in the A.mdb to the relevant table in B.Mdb and C.mdb then
the following should work to give you a unique list of...
Forum: Running & Setting Up Queries February 12th, 2010, 11:49 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 197
Posted By cinnie
SQL help needed please

greetings gurus

I am having trouble with the syntax of a query I'm trying to write. Here is
the situation, simpified to its essence:
C:/DB/A.mdb has tblNames with relevant fields CustID, CustName,...
Forum: Running & Setting Up Queries February 5th, 2010, 12:06 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 217
Posted By cinnie
SELECT vs. ORDER BY - order of execution question

hi Sylvain - thanks for your response. It gives me some good insights.
--
cinnie


"Sylvain Lafontaine" wrote:

HI Cinnie - For your original question, the answer are both yes and no:
...
Forum: Running & Setting Up Queries February 4th, 2010, 11:26 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 217
Posted By cinnie
SELECT vs. ORDER BY - order of execution question

hi Sylvain - thank you for your insights. I still don't feel that my
original question has found an answer, although I do think I get now what you
are saying about ALIAS. I'm simply trying to...
Forum: Running & Setting Up Queries February 4th, 2010, 07:11 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 217
Posted By cinnie
SELECT vs. ORDER BY - order of execution question

hello Karl

I'm having trouble understanding this answer because it makes no use of the
ORDER BY clause. I'm trying to determine whether ORDER BY or SELECT is
processed first in SQL. Any...
Forum: Running & Setting Up Queries February 4th, 2010, 04:52 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 217
Posted By cinnie
SELECT vs. ORDER BY - order of execution question

hello

In SQL, is SELECT executed before ORDER BY, or after. Here's why I'm
confused about this;

Consider table tblEmp with fields EmpID, Name_F, Name_L, Wage

SELECT tblEmpID,...
Forum: Running & Setting Up Queries January 29th, 2010, 06:29 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 110
Posted By cinnie
BETWEEN a rock AND a hard place

hello gurus

This isn't a question as much as it is a beginner's comment on
BETWEEN...AND. As it seems to be used, BETWEEN...AND gives results that are
inclusive at both ends. (BETWEEN 10 and 20...
Showing results 1 to 25 of 67

 
Forum Jump

All times are GMT +1. The time now is 10:52 PM.


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