Recent content by pdavis41

Attached is a trimed down version of the database. I have three tables that I am pulling data from to create a third table. This table is called clean sheet. It is displayed as follows: CleanSheetID // MeritBadgeID // Camper ID // RequirementID // Completed Each of the colums is a numeric...

I am thinking that the best way to approach this is with a seperate query and a subreport for the previous total. Since I am loading the report by a form the query will pull the week number from the form and total everything previous to it. The problem I am getting is that the report is...

Bumb I'm putting off working on this section of the program right now and working on another part. If anyone has any ideas please let me know.

Disclaimer: This got way more complicated that I was planning on! Ok so here is what I'm trying to do: The report that I am trying to make is basically a general ledger sheet. I am currently using the Microsoft Dynamic Cross Tab Report modified to my need. Here is what the report needs to...

GOT IT!!!! The problem with the report was that the names of the sections were wrong... For example the header section of code was This was causing the header not to be formated because it was not named PaterHeader1. I will post the final report for people to referance.

I've solved half of my problem. I have got the query to do what I want. It is now updating with each new reciept and totaling everything on one line per reciept. I still havent gotten the report to display the data right. I took the code from the sample but it is only displaying empty boxes...

I have started playing around with the samples9.mdb and have set up the code for the dynamic cross tab report. I guess the major problem I'm having is that the cross tab is not looking the way i want it to. I want one line to appear per recipet but I am getting the number of lines that there...

I am trying to create a very custom report for a accounting program I am working on, and I am having great difficulties. The report needs to look like this: Reciept Date Payee PO Number Reciept Total Account Acccount Account Account..... As you can see it is...