K
knowshowrosegrows
My user is calling all our funded programs daily and getting their census
amount. She inputs that into a form. Ultimately, that number is compared
with the capacity the program has and we calculate slots available on any
given day.
My table structure is roughly:
tblAgency w/
Agency_ID (Auto Number) PK
AgencyName (Text)
tblProgram w/
Prm_Code PK
Agency_ID FK
tblCensusEvent
CensusEvent_ID (Auto Number) PK
Prm_Code FK
CensusDate
CensusAmount
I am trying to build a query that will ask for a search date (I understand
parameters) and then give me a report with ALL the programs AND the census
data for any programs that reported it on that date.
I just finished "Database Design for Mere Mortals," but I havent started
"SQL Queries for Mere Mortals..."
amount. She inputs that into a form. Ultimately, that number is compared
with the capacity the program has and we calculate slots available on any
given day.
My table structure is roughly:
tblAgency w/
Agency_ID (Auto Number) PK
AgencyName (Text)
tblProgram w/
Prm_Code PK
Agency_ID FK
tblCensusEvent
CensusEvent_ID (Auto Number) PK
Prm_Code FK
CensusDate
CensusAmount
I am trying to build a query that will ask for a search date (I understand
parameters) and then give me a report with ALL the programs AND the census
data for any programs that reported it on that date.
I just finished "Database Design for Mere Mortals," but I havent started
"SQL Queries for Mere Mortals..."