Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pclutts

    Restricting Access to Back & Front End

    My database has a front and back end. To get into the system, the user double-clicks on the icon for an Updater-Launcher that checks the master front end for new versions of forms, queries, reports, etc., before going into the database. The front and back ends are both on our LAN, but just in...
  2. pclutts

    Sum 4 Fields on a Report

    Thanks a bunch Paul for the help. Your advise was exactly right. I guess I couldn't see the forest for the trees.
  3. pclutts

    Sum 4 Fields on a Report

    I have a report I'm stumped on. The Record Source for the report is a query called qryDBESummaryRpt. This query is made from two tables: tblDBE and tblProjects. For this query, these two tables are related via a field called ProjectID, which appears in each table but originates from tblProjects...
  4. pclutts

    Problems with Border Around Report

    I have a report named rptConstInsp with a border around the perimeter of the Detail Section. Often times the data in this Detail Section forces a new page because of all the construction inspection information typed in. The data shows up on the second page, but the border around the Detail...
  5. pclutts

    Calculating a Percentage

    To PaulBricker: Thanks loads for the advise. It worked. Here's the formula I used; PEREST: (([CNTRAMT]/[ENGSESTIM])-1)*100
  6. pclutts

    Calculating a Percentage

    I have a form (record source is table named tblBidTabs) with a field named PEREST. This value is the percent the low bid is over or under the engineer's estimate. The field name for the low bid is CNTRAMT, and the field name for the engineer's estimate is ENGSESTIM. Can I do the calculation...
  7. pclutts

    Update Query?

    I have a text field (named ProjNo) in table tblBidTabs where project numbers now exist. I want to convert that field to a combo box where I look up the project number names in table tblProjects. However, I don't want to loose the Project Number data that already exists in tblBidTabs. Also, when...

Part and Inventory Search

Back
Top