Should I use a query or module?

[LaurelLee]

I am attempting to change the information displayed on a report, and am not quite sure where to start.
Two of the columns' data will need to display more values than they do now. These values will be displayed based on a criteria of department holds that the current project has had placed on it that barred the work from being completed, and the corresponding date when the hold was lifted. The report needs to display all of these from conception till now. Currently, only the most recent hold is being displayed.
I am not too familiar with the database or its' modules, and keep spinning my wheels on what to do or where to start. Any comments that you all have will be much appreciated!
~~LL

 

[LonnieJohnson]

If you have a report, the data that is displayed is determined by the underlying recordsource. Is the report fed by a query or table? If it is fed by a query, is the criteria hard coded or does it get it from a form or function?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[LaurelLee]

The data comes from two make tables, a query(that calls other queries within it), and a table. It appears that the data is hard coded within the queries. I am a beginner and am not sure where I should start! The problem itself seems simple, but when I try to put it in the context of the existing code and queries, I get overwhelmed. Thanks for the advice!

 

[LonnieJohnson]

So is your problem with changing the existing criteria that in the queries? If so, what is it now and what do you want to change it to?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[LaurelLee]

I don't know if changing the queries will help. The way the report runs now is this: If there is a hold from another department on the project, two colums are populated with the hold source and the date (if the hold has been released). I need it to display a history of any holds and their corresponding dates for each record. When I look at the queries it is not clear to me what I need to change, as they are fairly cryptic and not commented. Unfortunately, I have nobody to ask, because nobody but the users are familiar with this report. The holds are determined by a lengthy case statement within a module. At first, I thought that I would be able to add code to the module, but when I sat down to do this, it didn't seem like the right thing to do.

 

[LonnieJohnson]

It sounds like you may need someone to look at your code and the setup of your application to help determine what you need to do.

Without doing that, it is hard for me to say what you should do at this point.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[LaurelLee]

That is what I kind of thought. My problem with that is that I am in a sea of people who know nothing about this application. I am ready to scrap it and write it over from scratch! Thanks for your help, Lonnie!

 

[tracy1234]

LaurelLee-

If you don't understand the existing queries, etc, then start by looking for the data in the tables. You want a history of holds. Look at the tables to see if this data is stored somewhere.

It sounds like you have some code to put a project on hold. It sounds like your current report is showing you the current holds. What you need to find is if past holds exist in your tables. If they do exist, you may find it easy to extract that information directly. If they don't exist, then you may be out of luck.

-Tracy