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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by AGoodGuy

  1. AGoodGuy

    Query Question

    I have a question. Since I dont work on the weekends I have to still account for data for Friday and Saturday since my daily data reflects the day before. I have a field name that I focus on. The field names is Expiration date and I have it as >=Date()-32. Since I am not in the office to...
  2. AGoodGuy

    Query Help

    I have another question. Since I dont work on the weekends I have to still account for data for Friday and Saturday since my daily data reflects the day before. I have a field name that I focus on. The field names is Expiration date and I have it as >=Date()-32. Since I am not in the office...
  3. AGoodGuy

    Query Help

    dhookum: That worked perfectly...thanks
  4. AGoodGuy

    Query Help

    I have a query and I am trying to figure out something. I have a field name that says Policy Number Policy Number RN Offer Duplicate ALA000000000 Renewal Offer Letter Duplicate ALA000000000 Renewal Offer Letter Duplicate ALA000000001 If the Policy Number fieldname...
  5. AGoodGuy

    Query Help

    I have Query 1 results - AAL Male 23 I have Query 2 results - AAL Female 33 How to combine the two queries to get the results below: AAL Male 23 AAL Female 33 Would I need to a union query?
  6. AGoodGuy

    Formula Help

    I have a query that I created. I have two fields that I matched from the queries: 26 Daily Policies Expired.PolicyNumber and 03 Renewal Offer Analysis.Policy Number. If the policy number is showing for 26 Daily Policies Expired.PolicyNumber and not showing for 03 Renewal Offer Analysis.Policy...
  7. AGoodGuy

    Query Help

    I need help...I have fieldnames called Method, Auto/Manual and Payment Type from the table dbo_UWA_PaymentLog I need a formula in my qeury to show the following: (1)If Method = Epay and Auto/Manual = Auto then Payment Type = WEB PAY (2)If Method = Epay and Auto/Manual = Manual then Payment...
  8. AGoodGuy

    Macro Question

    I have a standard report done in Access 2007. Is it possible to create a macro in VBA to have that standard report sent to coworkers at a certain time?
  9. AGoodGuy

    Macro

    I have a standard report done in Access 2007. Is it possible to create a macro to have that standard report sent to cowrokers at a certian time?
  10. AGoodGuy

    Weekend Data

    I have the fieldname ExpDate set to Date()+32; which gives me the data for the policies with an expiration date of 11/18/2011. For expamle renewal offers goes out to customers with an expiration date of 11/18/2011 but the leeter went out yesterday being 10/16/2011. I would like to capture the...
  11. AGoodGuy

    Weekend Data

    I have a date field called Expiration date. Since I work on Monday - Friday, how would I be able to collect datat for Saturday and Sunday?
  12. AGoodGuy

    Formula in Access Query

    Policy Fee and State Policy Fee. What I have done is create an unmatch query to pull out any policies with a different policy fee other than what is should be. I match the field name policy fee form the query against the State policy fee from the table and had the fallouts of any policies...
  13. AGoodGuy

    Formula in Access Query

    The common field that should match is the Policy fee in the query and the State policy Fees in the table. They both should match.
  14. AGoodGuy

    Formula in Access Query

    Question for you... I have a table and a query that I created below: STATE POLICY FEE Table (Table I created from scratch) State Transaction State policy fees Term Payplan 03Renewal Offere Analysis (Query) STATE PolicyNumber Policy Fee I am trying to see if there the policy fees from the...
  15. AGoodGuy

    Formula in Access Query

    Dhookem...you are correct...It was a typo on my end. I thought since I changed the expression name in the query that I had to include it in the formula. I believe this formula will work for me. Thanks as always.

Part and Inventory Search

Back
Top