Search results

  1. C

    Combine 2 criteria into a single criteria to show win/loss

    I have a field which has 3 criteria: Active, Closed, Have Pricing. I want to combine the active and closed into one criteria called "Won" and the Have pricing will be called "Lost". Is this possible???
  2. C

    If duplicate is found,.....

    I have a field that I am using code to find a duplicate on BeforeUpdate. That part of the code works fine, however, I would like for the field to either sav a null or zero value in and not allow the AfterUpdate on the same field to work. Here is the code I am using below: If DCount("[Job...
  3. C

    Query dates within the same week from 2 different columns

    I am trying to populate a query that uses the dates within the current week from 2 different coulmns. The code I am using is below: DatePart("ww", [Date Bid Sent]) = DatePart("ww", Date()) and Year([Date Bid Sent]) = Year(Date()) I want to also query, on the same query, Jobs started [Start Date]...
  4. C

    Sort for High, Medium, Low

    I amtrying to sort a query and a report to "high, medium, and low" I have looked at several threads on this forum to answer that question, But i guess i am still so new, i cant quite figure out how to do this. I have created a column for 'Priority", and "priority by number" to facilitate this...
  5. C

    Dsum giving a wrong amount

    I am trying to sum the amount of Jobs started that are quoted vs the jobs that are not quoted. I am using the following code: =DSum("
  6. C

    Calculate Profit margin and place in table as %

    I am trying to use the code below to determine profit margin, However, I want the sum to show as a percent in the table and Form. Please Help! Me.Margin = (Me.Quote_Amount - Me.Cost) / Me.Cost / 100 This is returning a "0" in the field
  7. C

    If 2 conditions are met, then change field, if one of those is not met, Then leave.

    I am trying to make sure 2 conditions are met before changing the field. If one of those conditions is NOT met, Then I want the fields to be left alone. Here is my beginner, Feable attempt at doing this: Private Sub Quote_Amount_AfterUpdate() If Me.Quote_Amount.Value > 0 & Me.Job_Number.Value...
  8. C

    If Statement - when condtions are not met, then leave field alone

    I am trying to make sure 2 conditions are met before changing the field. If one of those conditions is NOT met, Then I want the fields to be left alone. Here is my beginner, Feable attempt at doing this: Private Sub Quote_Amount_AfterUpdate() If Me.Quote_Amount.Value > 0 & Me.Job_Number.Value...
  9. C

    double click on data sheet form and go to specific record in a form

    I am new to Access, and am trying to go from a datasheet that is based on a query to a form that is based on a table. I want it to pull up the specific line I am double clicking on in the datasheet. PLEASE HELP Here is the code I am using: Private Sub Form_DblClick(Cancel As Integer) On Error...
Back
Top Bottom