Turn data into subdata

[Guest]

I have a table with lookup the field named [Contact Code]. One of the choices
is Internet. My boss said that he wanted to keeep track of the type of
internet-contact source: Yahoo, google, MSN, etc. I added a new field to the
table and named it [internet Contact Code]. No problem, yet. I also have
already a report that shows the total contacts for each [contact code].

The problem is that he wants the total number of internet contacts, from the
[contact Code] and the breakdown of the [Internet Contact Code] in the same
report. For example:

Current report New report
newspaper 10 newspaper 10
internet 20 internet:
yahoo 10
msn 10

I wasn't told this when I added the [Internet Contact Code]. What can I do
know?
Any help will be appreciated.

 

[Joseph Meehan]

I have a table with lookup the field named [Contact Code]. One of the
choices is Internet. My boss said that he wanted to keeep track of
the type of internet-contact source: Yahoo, google, MSN, etc. I added
a new field to the table and named it [internet Contact Code]. No
problem, yet. I also have already a report that shows the total
contacts for each [contact code].

The problem is that he wants the total number of internet contacts,
from the [contact Code] and the breakdown of the [Internet Contact
Code] in the same report. For example:

Current report New report
newspaper 10 newspaper 10
internet 20 internet:
yahoo 10
msn 10

I wasn't told this when I added the [Internet Contact Code]. What can
I do know?
Any help will be appreciated.

I guess I can't figure out what your table looks like.

I suggest you can have a field called contact. Valid contact entries
could be newspaper, yahoo or msn.

From there you should be able to count each and keep a running total
where the entry is not newspaper in a report.

 

[Guest]

I have a table with lookup the field named [Contact Code]. One of the
choices is Internet. My boss said that he wanted to keeep track of
the type of internet-contact source: Yahoo, google, MSN, etc. I added
a new field to the table and named it [internet Contact Code]. No
problem, yet. I also have already a report that shows the total
contacts for each [contact code].

The problem is that he wants the total number of internet contacts,
from the [contact Code] and the breakdown of the [Internet Contact
Code] in the same report. For example:

Current report New report
newspaper 10 newspaper 10
internet 20 internet:
yahoo 10
msn 10

I wasn't told this when I added the [Internet Contact Code]. What can
I do know?
Any help will be appreciated.

I guess I can't figure out what your table looks like.

I suggest you can have a field called contact. Valid contact entries
could be newspaper, yahoo or msn.

From there you should be able to count each and keep a running total
where the entry is not newspaper in a report.

I have a table with several fileds, one of them is a lookup field named
[Contact Code] the data in it is: Bus, Radio, newspaper, Yellow pages,
Internet.

My boss wanted to add Yahoo, MSN and Google to the table. What I did was to
create a NEW field named [Internet Contact Code]. I did not add these new
codes to the [Contact Code] field.

Now, my boss wants a breakdown of the internet codes. For example if there
were 30 internet contacts during the week (from the [Contact Code] field), he
wants to know how many were from yahoo, msn or google (from the [Internet
Contact Code])

I can get the total internet contacts from the [contact code] field in a
report, I can get the breakdown from the [Internet Contact Code] in a
different report. My problem is:
How can I put them in a single report?

I am thinking of a combo box maybe(?)

 

[Joseph Meehan]

I have a table with lookup the field named [Contact Code]. One of
the choices is Internet. My boss said that he wanted to keeep
track of the type of internet-contact source: Yahoo, google, MSN,
etc. I added a new field to the table and named it [internet
Contact Code]. No problem, yet. I also have already a report that
shows the total contacts for each [contact code].

The problem is that he wants the total number of internet contacts,
from the [contact Code] and the breakdown of the [Internet Contact
Code] in the same report. For example:

Current report New report
newspaper 10 newspaper 10
internet 20 internet:
yahoo 10
msn 10

I wasn't told this when I added the [Internet Contact Code]. What
can I do know?
Any help will be appreciated.

I guess I can't figure out what your table looks like.

I suggest you can have a field called contact. Valid contact
entries could be newspaper, yahoo or msn.

From there you should be able to count each and keep a running
total where the entry is not newspaper in a report.

I have a table with several fileds, one of them is a lookup field
named [Contact Code] the data in it is: Bus, Radio, newspaper, Yellow
pages, Internet.

My boss wanted to add Yahoo, MSN and Google to the table. What I did
was to create a NEW field named [Internet Contact Code]. I did not
add these new codes to the [Contact Code] field.

Now, my boss wants a breakdown of the internet codes. For example if
there were 30 internet contacts during the week (from the [Contact
Code] field), he wants to know how many were from yahoo, msn or
google (from the [Internet Contact Code])

I can get the total internet contacts from the [contact code] field
in a report, I can get the breakdown from the [Internet Contact
Code] in a different report. My problem is:
How can I put them in a single report?

I am thinking of a combo box maybe(?)

Maybe I don't understand your question, but here goes. Assuming there
are internet contacts and non-internet contacts, you can filter the report
to include only the new internet contacts. I would likely use a query with
new fields like Yahoo: (iif ([Internet Contact Code] = "yahoo") 1, 0) and
another for msn etc.

Frankly I think I would consider adding a field for each contact code
and make them binary type in the table and eliminate the existing text
field.

Please excuse any syntax errors as I was just winging it quickly.