T
TBoe
I need to create 4 reports. It is a Loan Closet d/b. The object is a person
comes in and checks out a wheelchair for instance. I have a table with
fields being a check out date, ck in date, etc. One of the reports are for
number of clients served each month and then a yearly total. Same with Item
out and Item ck in each month and a yearly total. I don't know SQL so I was
trying to use the query grid but to no avail. The last report involves 4
"Codes" and they want to be able to produce a report by breaking down each
code per month and again yearly. For the 1st report I figure I would have to
total up both the ck in and ck out but I'm not sure how to break it down into
months and for the year. Any help would be greatly appreciated. Thank you.
comes in and checks out a wheelchair for instance. I have a table with
fields being a check out date, ck in date, etc. One of the reports are for
number of clients served each month and then a yearly total. Same with Item
out and Item ck in each month and a yearly total. I don't know SQL so I was
trying to use the query grid but to no avail. The last report involves 4
"Codes" and they want to be able to produce a report by breaking down each
code per month and again yearly. For the 1st report I figure I would have to
total up both the ck in and ck out but I'm not sure how to break it down into
months and for the year. Any help would be greatly appreciated. Thank you.