Turn data into subdata

[Ricoy-Chicago]

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.

 

[Ricoy-Chicago]

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(?)