Re-Help! My Dlookup function doesn't work for DHookum

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

This is a message for Duane Hookum who has been helping me with a Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message. Could you post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of the posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
 
I am confused by the thread(s) also. I thought it was just me getting old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date which is
"Date()" then think about how you could change the following to reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions many times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean? I didn't
see these in the sample records you provided. It may be that you could add
another field as a Row Heading.
==============
 
Yes that was about 6 posts ago have Tek Tips got server problems do you
know. The last discussion we were having was on normalisation did you get my
last note?
Tony
Duane Hookom said:
I am confused by the thread(s) also. I thought it was just me getting old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date which is
"Date()" then think about how you could change the following to reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions many times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean? I didn't
see these in the sample records you provided. It may be that you could add
another field as a Row Heading.
==============
--
Duane Hookom
MS Access MVP
--

Tony Williams said:
This is a message for Duane Hookum who has been helping me with a Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message. Could you
post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of the posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
Click to expand...
Click to expand...
 
It seems that my last response to you was that your table structure was
definitely un-normalized and I would not proceed trying to create a report
until you were working with a normalized table structure where your
"types/categories of business" were not field names. I would expect to begin
working with a table or query that contained at the most about 5 fields
where you had a field named "BusinessCategory". This would increase the
number of records in your table by a factor of how many types you currently
have as fields.

Did you ever read and respond to this suggestion? If so, it is missing.

--
Duane Hookom
MS Access MVP
--

Tony Williams said:
Yes that was about 6 posts ago have Tek Tips got server problems do you
know. The last discussion we were having was on normalisation did you get
my
last note?
Tony
Duane Hookom said:
I am confused by the thread(s) also. I thought it was just me getting
old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date which is
"Date()" then think about how you could change the following to reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions many times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean? I didn't
see these in the sample records you provided. It may be that you could
add
another field as a Row Heading.
==============
--
Duane Hookom
MS Access MVP
--

Tony Williams said:
This is a message for Duane Hookum who has been helping me with a Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message. Could you
post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of the posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
Click to expand...
Click to expand...
Click to expand...
 
Yes Duane I did. I understand normalisation to mean not repeating data in a
record when it can be held in another table, eg in a stock control system
you would not hold the suppliers address everytime only the suppliers name,
the address would then be in a linked table. Am I right? If that is the case
I'm not sure how I can change my table. All the numeric data held in my 7
fields is unique to each record and there is no repeating "category of
business" The only fields that hold data that will appear in multiple
records is txtcompany and txtmonthlabel. These two fields identify which
company and for which date the data in the 7 unique fields belongs to. Am I
missing something here?
As ever, thanks for your input
Tony
Duane Hookom said:
It seems that my last response to you was that your table structure was
definitely un-normalized and I would not proceed trying to create a report
until you were working with a normalized table structure where your
"types/categories of business" were not field names. I would expect to begin
working with a table or query that contained at the most about 5 fields
where you had a field named "BusinessCategory". This would increase the
number of records in your table by a factor of how many types you currently
have as fields.

Did you ever read and respond to this suggestion? If so, it is missing.

--
Duane Hookom
MS Access MVP
--

Tony Williams said:
Yes that was about 6 posts ago have Tek Tips got server problems do you
know. The last discussion we were having was on normalisation did you get
my
last note?
Tony
Duane Hookom said:
I am confused by the thread(s) also. I thought it was just me getting
old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date which is
"Date()" then think about how you could change the following to reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions many times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean? I didn't
see these in the sample records you provided. It may be that you could
add
another field as a Row Heading.
==============
--
Duane Hookom
MS Access MVP
--

This is a message for Duane Hookum who has been helping me with a Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message. Could you
post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of the posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
Click to expand...
Click to expand...
Click to expand...
 
Duane sorry my mistake I have 14 fields which all hold different data not 7
as I said in the previous post
Tony
Duane Hookom said:
It seems that my last response to you was that your table structure was
definitely un-normalized and I would not proceed trying to create a report
until you were working with a normalized table structure where your
"types/categories of business" were not field names. I would expect to begin
working with a table or query that contained at the most about 5 fields
where you had a field named "BusinessCategory". This would increase the
number of records in your table by a factor of how many types you currently
have as fields.

Did you ever read and respond to this suggestion? If so, it is missing.

--
Duane Hookom
MS Access MVP
--

Tony Williams said:
Yes that was about 6 posts ago have Tek Tips got server problems do you
know. The last discussion we were having was on normalisation did you get
my
last note?
Tony
Duane Hookom said:
I am confused by the thread(s) also. I thought it was just me getting
old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date which is
"Date()" then think about how you could change the following to reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions many times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean? I didn't
see these in the sample records you provided. It may be that you could
add
another field as a Row Heading.
==============
--
Duane Hookom
MS Access MVP
--

This is a message for Duane Hookum who has been helping me with a Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message. Could you
post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of the posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
Click to expand...
Click to expand...
Click to expand...
 
I had a very direct reply to a similar message in TT that your 14 fields
should be 14 records. I think I pointed out what it would look like in the
Northwind database if the Orders table had separate fields for each
ProductID rather than a related table of OrderDetails where each ProductID
creates its own record.

Any solution that you design should anticipate the addition of a 15th, 16th,
or possibly the deletion of a "field". I had this whole explaination of
getting lego blocks shaped into cars from your customers. Your reports
require the blocks shaped into houses. You are attempting to create houses
from the cars. I would break down the cars into individual blocks and then
build the houses.

Luckily with tables and data you can keep your cars but create copies of the
blocks in new tables which could be transformed into houses.

My bottom-line recommendation is to:
- create your normalized tables (blocks)
- specify how you want your reports to display (size and shape of houses)
- build your reports (be a carpenter)
- if you can't create your reports, come to use with:
o description of your normalized data (the blocks)
o report specs (house blueprints)
or
o hire an architect and carpenter

--
Duane Hookom
MS Access MVP
--


Tony Williams said:
Duane sorry my mistake I have 14 fields which all hold different data not
7
as I said in the previous post
Tony
Duane Hookom said:
It seems that my last response to you was that your table structure was
definitely un-normalized and I would not proceed trying to create a
report
until you were working with a normalized table structure where your
"types/categories of business" were not field names. I would expect to begin
working with a table or query that contained at the most about 5 fields
where you had a field named "BusinessCategory". This would increase the
number of records in your table by a factor of how many types you currently
have as fields.

Did you ever read and respond to this suggestion? If so, it is missing.

--
Duane Hookom
MS Access MVP
--

Tony Williams said:
Yes that was about 6 posts ago have Tek Tips got server problems do you
know. The last discussion we were having was on normalisation did you get
my
last note?
Tony
I am confused by the thread(s) also. I thought it was just me getting
old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date which is
"Date()" then think about how you could change the following to reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions many
times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean? I
didn't
see these in the sample records you provided. It may be that you could
add
another field as a Row Heading.
==============
--
Duane Hookom
MS Access MVP
--

This is a message for Duane Hookum who has been helping me with a
Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message. Could you
post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of the
posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
Click to expand...
Click to expand...
Click to expand...
 
Thanks Duane I like the analogy. It's 2056 here in the Uk and I think the day
has been long enough I'll be back on this tomorrow.
Thanks again
Tony

Duane Hookom said:
I had a very direct reply to a similar message in TT that your 14 fields
should be 14 records. I think I pointed out what it would look like in the
Northwind database if the Orders table had separate fields for each
ProductID rather than a related table of OrderDetails where each ProductID
creates its own record.

Any solution that you design should anticipate the addition of a 15th, 16th,
or possibly the deletion of a "field". I had this whole explaination of
getting lego blocks shaped into cars from your customers. Your reports
require the blocks shaped into houses. You are attempting to create houses
from the cars. I would break down the cars into individual blocks and then
build the houses.

Luckily with tables and data you can keep your cars but create copies of the
blocks in new tables which could be transformed into houses.

My bottom-line recommendation is to:
- create your normalized tables (blocks)
- specify how you want your reports to display (size and shape of houses)
- build your reports (be a carpenter)
- if you can't create your reports, come to use with:
o description of your normalized data (the blocks)
o report specs (house blueprints)
or
o hire an architect and carpenter

--
Duane Hookom
MS Access MVP
--


Tony Williams said:
Duane sorry my mistake I have 14 fields which all hold different data not
7
as I said in the previous post
Tony
Duane Hookom said:
It seems that my last response to you was that your table structure was
definitely un-normalized and I would not proceed trying to create a
report
until you were working with a normalized table structure where your
"types/categories of business" were not field names. I would expect to begin
working with a table or query that contained at the most about 5 fields
where you had a field named "BusinessCategory". This would increase the
number of records in your table by a factor of how many types you currently
have as fields.

Did you ever read and respond to this suggestion? If so, it is missing.

--
Duane Hookom
MS Access MVP
--

Yes that was about 6 posts ago have Tek Tips got server problems do you
know. The last discussion we were having was on normalisation did you get
my
last note?
Tony
I am confused by the thread(s) also. I thought it was just me getting
old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date which is
"Date()" then think about how you could change the following to reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions many
times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean? I
didn't
see these in the sample records you provided. It may be that you could
add
another field as a Row Heading.
==============
--
Duane Hookom
MS Access MVP
--

This is a message for Duane Hookum who has been helping me with a
Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message. Could you
post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of the
posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
Click to expand...
Click to expand...
Click to expand...
 
Dream of Legos and houses tonight.

--
Duane Hookom
MS Access MVP
--

Tony Williams said:
Thanks Duane I like the analogy. It's 2056 here in the Uk and I think the
day
has been long enough I'll be back on this tomorrow.
Thanks again
Tony

Duane Hookom said:
I had a very direct reply to a similar message in TT that your 14 fields
should be 14 records. I think I pointed out what it would look like in
the
Northwind database if the Orders table had separate fields for each
ProductID rather than a related table of OrderDetails where each
ProductID
creates its own record.

Any solution that you design should anticipate the addition of a 15th,
16th,
or possibly the deletion of a "field". I had this whole explaination of
getting lego blocks shaped into cars from your customers. Your reports
require the blocks shaped into houses. You are attempting to create
houses
from the cars. I would break down the cars into individual blocks and
then
build the houses.

Luckily with tables and data you can keep your cars but create copies of
the
blocks in new tables which could be transformed into houses.

My bottom-line recommendation is to:
- create your normalized tables (blocks)
- specify how you want your reports to display (size and shape of houses)
- build your reports (be a carpenter)
- if you can't create your reports, come to use with:
o description of your normalized data (the blocks)
o report specs (house blueprints)
or
o hire an architect and carpenter

--
Duane Hookom
MS Access MVP
--


Tony Williams said:
Duane sorry my mistake I have 14 fields which all hold different data
not
7
as I said in the previous post
Tony
It seems that my last response to you was that your table structure
was
definitely un-normalized and I would not proceed trying to create a
report
until you were working with a normalized table structure where your
"types/categories of business" were not field names. I would expect to
begin
working with a table or query that contained at the most about 5
fields
where you had a field named "BusinessCategory". This would increase
the
number of records in your table by a factor of how many types you
currently
have as fields.

Did you ever read and respond to this suggestion? If so, it is
missing.

--
Duane Hookom
MS Access MVP
--

Yes that was about 6 posts ago have Tek Tips got server problems do
you
know. The last discussion we were having was on normalisation did
you
get
my
last note?
Tony
I am confused by the thread(s) also. I thought it was just me
getting
old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date which
is
"Date()" then think about how you could change the following to
reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions
many
times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean?
I
didn't
see these in the sample records you provided. It may be that you
could
add
another field as a Row Heading.
==============
--
Duane Hookom
MS Access MVP
--

This is a message for Duane Hookum who has been helping me with a
Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message.
Could
you
post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of
the
posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
Click to expand...
Click to expand...
Click to expand...
 
Hope you see this Duane! I've been looking at my application and have got to
the stage where I can't see the wood for the trees! Am I going too far in
the use of Newsgroups to give a brief outline of how we get the information
and ask for some ideas as to how we should structure the database. If you
think that would be acceptable what Newsgroup should I post it too. I am
somewhat reluctant to do it as it seems a bit like asking for free
consultancy and that is just not me. Asking for help on individual problems
is one thing and I wondered whether this would be stretching everyone's good
nature. As you have probably guessed our problem is resources both manpower
and financial.
Any guidance would be appreciated
Tony
Duane Hookom said:
I had a very direct reply to a similar message in TT that your 14 fields
should be 14 records. I think I pointed out what it would look like in the
Northwind database if the Orders table had separate fields for each
ProductID rather than a related table of OrderDetails where each ProductID
creates its own record.

Any solution that you design should anticipate the addition of a 15th, 16th,
or possibly the deletion of a "field". I had this whole explaination of
getting lego blocks shaped into cars from your customers. Your reports
require the blocks shaped into houses. You are attempting to create houses
from the cars. I would break down the cars into individual blocks and then
build the houses.

Luckily with tables and data you can keep your cars but create copies of the
blocks in new tables which could be transformed into houses.

My bottom-line recommendation is to:
- create your normalized tables (blocks)
- specify how you want your reports to display (size and shape of houses)
- build your reports (be a carpenter)
- if you can't create your reports, come to use with:
o description of your normalized data (the blocks)
o report specs (house blueprints)
or
o hire an architect and carpenter

--
Duane Hookom
MS Access MVP
--


Tony Williams said:
Duane sorry my mistake I have 14 fields which all hold different data not
7
as I said in the previous post
Tony
Duane Hookom said:
It seems that my last response to you was that your table structure was
definitely un-normalized and I would not proceed trying to create a
report
until you were working with a normalized table structure where your
"types/categories of business" were not field names. I would expect to begin
working with a table or query that contained at the most about 5 fields
where you had a field named "BusinessCategory". This would increase the
number of records in your table by a factor of how many types you currently
have as fields.

Did you ever read and respond to this suggestion? If so, it is missing.

--
Duane Hookom
MS Access MVP
--

Yes that was about 6 posts ago have Tek Tips got server problems do you
know. The last discussion we were having was on normalisation did you get
my
last note?
Tony
I am confused by the thread(s) also. I thought it was just me getting
old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date which is
"Date()" then think about how you could change the following to reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions many
times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean? I
didn't
see these in the sample records you provided. It may be that you could
add
another field as a Row Heading.
==============
--
Duane Hookom
MS Access MVP
--

This is a message for Duane Hookum who has been helping me with a
Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message. Could you
post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of the
posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
Click to expand...
Click to expand...
Click to expand...
 
The primary problem that I see is your table structure. This type of
question might be better answered in the tablesdbdesign news group.
I have a tendency attempt to simplify everything. This is like breaking the
cars into blocks first. After you have blocks, you can create houses.
Creating blocks from cars is the table design or query question. Building
the houses from blocks is the report question.

--
Duane Hookom
MS Access MVP
--

Tony Williams said:
Hope you see this Duane! I've been looking at my application and have got
to
the stage where I can't see the wood for the trees! Am I going too far in
the use of Newsgroups to give a brief outline of how we get the
information
and ask for some ideas as to how we should structure the database. If you
think that would be acceptable what Newsgroup should I post it too. I am
somewhat reluctant to do it as it seems a bit like asking for free
consultancy and that is just not me. Asking for help on individual
problems
is one thing and I wondered whether this would be stretching everyone's
good
nature. As you have probably guessed our problem is resources both
manpower
and financial.
Any guidance would be appreciated
Tony
Duane Hookom said:
I had a very direct reply to a similar message in TT that your 14 fields
should be 14 records. I think I pointed out what it would look like in
the
Northwind database if the Orders table had separate fields for each
ProductID rather than a related table of OrderDetails where each
ProductID
creates its own record.

Any solution that you design should anticipate the addition of a 15th, 16th,
or possibly the deletion of a "field". I had this whole explaination of
getting lego blocks shaped into cars from your customers. Your reports
require the blocks shaped into houses. You are attempting to create
houses
from the cars. I would break down the cars into individual blocks and
then
build the houses.

Luckily with tables and data you can keep your cars but create copies of the
blocks in new tables which could be transformed into houses.

My bottom-line recommendation is to:
- create your normalized tables (blocks)
- specify how you want your reports to display (size and shape of houses)
- build your reports (be a carpenter)
- if you can't create your reports, come to use with:
o description of your normalized data (the blocks)
o report specs (house blueprints)
or
o hire an architect and carpenter

--
Duane Hookom
MS Access MVP
--


Tony Williams said:
Duane sorry my mistake I have 14 fields which all hold different data not
7
as I said in the previous post
Tony
It seems that my last response to you was that your table structure
was
definitely un-normalized and I would not proceed trying to create a
report
until you were working with a normalized table structure where your
"types/categories of business" were not field names. I would expect to
begin
working with a table or query that contained at the most about 5
fields
where you had a field named "BusinessCategory". This would increase
the
number of records in your table by a factor of how many types you
currently
have as fields.

Did you ever read and respond to this suggestion? If so, it is
missing.

--
Duane Hookom
MS Access MVP
--

Yes that was about 6 posts ago have Tek Tips got server problems do you
know. The last discussion we were having was on normalisation did
you
get
my
last note?
Tony
I am confused by the thread(s) also. I thought it was just me getting
old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date which is
"Date()" then think about how you could change the following to
reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions
many
times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean?
I
didn't
see these in the sample records you provided. It may be that you could
add
another field as a Row Heading.
==============
--
Duane Hookom
MS Access MVP
--

This is a message for Duane Hookum who has been helping me with a
Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message.
Could
you
post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of the
posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
Click to expand...
Click to expand...
Click to expand...
 
Thanks Duane
Tony
Duane Hookom said:
The primary problem that I see is your table structure. This type of
question might be better answered in the tablesdbdesign news group.
I have a tendency attempt to simplify everything. This is like breaking the
cars into blocks first. After you have blocks, you can create houses.
Creating blocks from cars is the table design or query question. Building
the houses from blocks is the report question.

--
Duane Hookom
MS Access MVP
--

Tony Williams said:
Hope you see this Duane! I've been looking at my application and have got
to
the stage where I can't see the wood for the trees! Am I going too far in
the use of Newsgroups to give a brief outline of how we get the
information
and ask for some ideas as to how we should structure the database. If you
think that would be acceptable what Newsgroup should I post it too. I am
somewhat reluctant to do it as it seems a bit like asking for free
consultancy and that is just not me. Asking for help on individual
problems
is one thing and I wondered whether this would be stretching everyone's
good
nature. As you have probably guessed our problem is resources both
manpower
and financial.
Any guidance would be appreciated
Tony
Duane Hookom said:
I had a very direct reply to a similar message in TT that your 14 fields
should be 14 records. I think I pointed out what it would look like in
the
Northwind database if the Orders table had separate fields for each
ProductID rather than a related table of OrderDetails where each
ProductID
creates its own record.

Any solution that you design should anticipate the addition of a 15th, 16th,
or possibly the deletion of a "field". I had this whole explaination of
getting lego blocks shaped into cars from your customers. Your reports
require the blocks shaped into houses. You are attempting to create
houses
from the cars. I would break down the cars into individual blocks and
then
build the houses.

Luckily with tables and data you can keep your cars but create copies
Click to expand...
of
the
blocks in new tables which could be transformed into houses.

My bottom-line recommendation is to:
- create your normalized tables (blocks)
- specify how you want your reports to display (size and shape of houses)
- build your reports (be a carpenter)
- if you can't create your reports, come to use with:
o description of your normalized data (the blocks)
o report specs (house blueprints)
or
o hire an architect and carpenter

--
Duane Hookom
MS Access MVP
--


Duane sorry my mistake I have 14 fields which all hold different data not
7
as I said in the previous post
Tony
It seems that my last response to you was that your table structure
was
definitely un-normalized and I would not proceed trying to create a
report
until you were working with a normalized table structure where your
"types/categories of business" were not field names. I would expect to
begin
working with a table or query that contained at the most about 5
fields
where you had a field named "BusinessCategory". This would increase
the
number of records in your table by a factor of how many types you
currently
have as fields.

Did you ever read and respond to this suggestion? If so, it is
missing.
Click to expand...
do
you
know. The last discussion we were having was on normalisation did
you
get
my
last note?
Tony
I am confused by the thread(s) also. I thought it was just me getting
old.
The last reply I see in the thread is:
==============
Tony,
If you don't want all of the quarters relative to todays date
Click to expand...
which
is
"Date()" then think about how you could change the following to
reference
some other date:

PIVOT "Q" & DateDiff("q",[Return Date],Date()) In
("Q0","Q1","Q2","Q3","Q4");

If you can't figure this out, I have answered similar questions
many
times.
Search google
http://www.google.com/search?query=hookom+crosstab+Report+Mth0

Regarding "provide a number of figures", what exactly do you mean?
I
didn't
see these in the sample records you provided. It may be that you could
add
another field as a Row Heading.
==============
--
Duane Hookom
MS Access MVP
--

This is a message for Duane Hookum who has been helping me with a
Dlookup
problem.
Duane - I cannot get into Tek tips to get your last message.
Could
you
post
it in here for me?
I have a problem with Tek Tips I can't log in and the last 6 of the
posts
are missing.
Sorry to contact you through here but didn't know any other way
Tony
Click to expand...
Click to expand...
Click to expand...
 
Back
Top