D
dperry
There is only a few simple things that I need from my queries...
I'm very sorry for the ease of these questions, but I seem to be a
"catch-all" I.T. specialist and I've never had to make a table that did
anything more than hold information
The database I'm creating is for finding out who can and cannot take
two different medications. First on the form is the employee and all of
his and his agency information. Then on a separte table is that
employee's name again, along with all of his household members, and
whether they cannot take either of the two medications. If the check
box is checked, then they can NOT take that medication. Then I need to
have a print out of all kinds of different reports from that
information... Once Again, I'm sorry for the ease of this, but google
searching didnt' really help me, and I need this database made up
quickly, so I dont have time to order a book to learn. The outputs I
put down include what I call a header (which is just some information
at the top of the page to divide up the reports). Anything that isn't
next to Header, is in a table type print out.
Some of the Inputs:
(Table One):
Name
County (By Look Up from Municipality, which I also dont know how to do)
Municipality (Drop Down List)
Agency Name
Agency Type (Drop Down List)
Agency Address
(Table Two):
HouseHold Member Name(which Includes Name)
CIPRO (checkbox)
DOXY (checkbox)
There are a few reports that I need from this, and to get them I need
to make queries.
(C) = Checked, (U) = Unchecked.
First One:
Header:Municipality
Agency Type
Total Number of HouseHold Members
Total Of: CIPRO(C) and DOXY(U)
Total Of: CIPRO(U) and DOXY(C)
Total Of: CIPRO(C) and DOXY(C)
Then I need grand totals of all the totals...
Second:
Header: County
Municipality
Total Of: CIPRO(U) and DOXY(U)
Total Of: CIPRO(U) and DOXY(C)
Total Of: CIPRO(C) and DOXY(U)
Total Of: CIPRO(C) and DOXY(C)
Then I need grand totals of all the totals...
Third:
Header: Agency Name, Agency Address, Municipality, Agency Type
Name
Total number of household members
Total Of: CIPRO(C) and DOXY(U)
Total Of: CIPRO(U) and DOXY(C)
Total Of: CIPRO(C) and DOXY(C)
Then I need grand totals of all the totals...
Talk to me as if I'm 3 years old, because I'm extremely new to this,
and have been only self taught Access, but I dont have time to learn it
all because this database needs to be done FAST.
I'm very sorry for the ease of these questions, but I seem to be a
"catch-all" I.T. specialist and I've never had to make a table that did
anything more than hold information
The database I'm creating is for finding out who can and cannot take
two different medications. First on the form is the employee and all of
his and his agency information. Then on a separte table is that
employee's name again, along with all of his household members, and
whether they cannot take either of the two medications. If the check
box is checked, then they can NOT take that medication. Then I need to
have a print out of all kinds of different reports from that
information... Once Again, I'm sorry for the ease of this, but google
searching didnt' really help me, and I need this database made up
quickly, so I dont have time to order a book to learn. The outputs I
put down include what I call a header (which is just some information
at the top of the page to divide up the reports). Anything that isn't
next to Header, is in a table type print out.
Some of the Inputs:
(Table One):
Name
County (By Look Up from Municipality, which I also dont know how to do)
Municipality (Drop Down List)
Agency Name
Agency Type (Drop Down List)
Agency Address
(Table Two):
HouseHold Member Name(which Includes Name)
CIPRO (checkbox)
DOXY (checkbox)
There are a few reports that I need from this, and to get them I need
to make queries.
(C) = Checked, (U) = Unchecked.
First One:
Header:Municipality
Agency Type
Total Number of HouseHold Members
Total Of: CIPRO(C) and DOXY(U)
Total Of: CIPRO(U) and DOXY(C)
Total Of: CIPRO(C) and DOXY(C)
Then I need grand totals of all the totals...
Second:
Header: County
Municipality
Total Of: CIPRO(U) and DOXY(U)
Total Of: CIPRO(U) and DOXY(C)
Total Of: CIPRO(C) and DOXY(U)
Total Of: CIPRO(C) and DOXY(C)
Then I need grand totals of all the totals...
Third:
Header: Agency Name, Agency Address, Municipality, Agency Type
Name
Total number of household members
Total Of: CIPRO(C) and DOXY(U)
Total Of: CIPRO(U) and DOXY(C)
Total Of: CIPRO(C) and DOXY(C)
Then I need grand totals of all the totals...
Talk to me as if I'm 3 years old, because I'm extremely new to this,
and have been only self taught Access, but I dont have time to learn it
all because this database needs to be done FAST.