Search results

Advice Thank You I am trying to figure a way to stop the duplicates, however the key here is how many places are duplicates being produced. I found this problem by creating a report to track project estimates and awards. I was getting to much information. I posted a thread in reports (To...

I need a little advice or review. I have a Data Base in Access 2000. I have been working on this for several years. The Data Base works pretty well for the reasons it was originally intended, however it has grown in directions that were not even thought of and I may need to go back and revise...

Patience Grasshopper, sorry if I had patience I probably would not be having this problem. I see it has been read, but no comments. I am concerned that I am not clear on the issue. Now I am thinking I may be on the wrong path here. Maybe the problem is not with the report so much as with the...

I hope this makes sense. I have a Report Based on a query. The query is based on the estimator, and a Date Range. The Report has the Estimator, Project Name, Bid Date, Bid Amount, Award Date & Award Amount. The Report then Calculates the Total Bids, and the Total Awards, divides the Awards...

Thanks for pointing me in the right direction. This is exactly what I was looking for. Now that I am getting the correct info, I think I should be able to create the report from the results. Thanks

Sorry, the key to looking up information to solve my own problem seems to be my lack of understanding what the problem is. I have created a report from Table information. When I open the report it brings up the estimator, the project name, the estimate amount and estimate date. It works...

Auto Numbering Thanks Pat I was under the impersion that the was some sore of auto numbering that went on, however you have opened my eyes. I am thinking along the lines of adding auto numbering to keep the data imput in the order it was enetred. I do understand that rows can not be inserted...

Thanks for all of your help. Pat I am reviewing the information you directed me to. It may be over my head, but I will keep at it. From the way I formed the question I as sure you realize I am not a data base person. Lets see if I can get it correct here. First I probaly posted this in an...

Thanks for your responce I left out a detail that may make a difference. There is a Purchase Order Entry Table where the date, project, address, vendor, and other same project related info is input. The actual Purchase Order (Items) information is entered in a subtable. I understand...

I currently have a input table where Purchase Orders are entered. The problem comes up with long orders containing Grouped Items. When I enter Group #1 items with several related items in rows directly below, then seperate them from Group #2 with a blank row. Everything looks fine while...

Exporting & Importing Thanks for your suggestion This may work, however I need to have users be able to export and import. The current office practice is to use an excell spreadsheet to compare items and prices. Once this step has been completed the Item Description and Unit Price is input...

I am not sure where to post this question if I am in the wrong area please let me know and I will move on. Thanks I am having some problems trying to export data; there must be a step I am missing. I have a data entry form for purchase orders. Several projects may require the identical...

Thank You for your help. Unfortunatly that did not work. I had actualy tried all of the Wildcard Characters, however after your response I tried again as I might have misentered something. I tried ??020401 and "??020401" (Never quite sure when I see a post in quotes if they are to be used...

I have a report based on a querry looking for Purchase Order Number. This works just fine, enter CM020401 and history report lists all of the Purchase Orders for this praject. On larger projects the Purchase Order Number is modified (to track seperate phases of project) by changing th first 2...

In case it matters I am using Access 2000 On the Purchase Order Form In the Project Name field the entry person picks the project from a combo box named ProjectName control cource is =[PoProjectName] row source is SELECT [Projects].[ProjectsID], [Projects].[ProjectName] FROM [Projects]...

Thanks for your help Jack. I am sorry but you are a little over my head. I am not exactly sure what you are telling me to do. I may need it a little more basic. I am relativly new to access. Have kind of forced my way through most of the stuff. Have a DB that is working (Kind of) although...

I have a table that contains project information ProjectName ProjectAddress ProjectNumber etc. I would like to have the PurchaseOrder form automaticaly enter the ProjectNumber on the form when the ProjectName is entered. I have been able to acomplish this in PurchaseOrder report, however I am...

I have a form that I was making some modifications to. It is now giving me problems and I would like to just get back to what I had before. I have a Zipped copy of my DB and am wondering if I could import my old form back into my main DB. There have been many data entries made since I messed...

Thank You =Sum([Quantity]*

Thanks I have been there before however I did go back and try again. I have also gone through Northwind. I am to a point where I can't see the forest for the trees. Sub Form Text Box name ExtendedPrice Control =[Quantity]*