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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: AGoodGuy
  • Content: Threads
  • Order by date
  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 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...
  3. 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?
  4. 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...
  5. 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...
  6. 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?
  7. 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?
  8. 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?
  9. AGoodGuy

    Formula in Access Query

    I have a query and in this query I have a field name called entdate which means enter date. I have about 15,000 rows of data as it gives me the individula policies. I would like to have a formula to give me weekly data from Sunday to Saturday.
  10. AGoodGuy

    Access Query

    I want to give more details..this is what I have Added Policy Fee:IIF([DanPols Renewal].STATE]=”AAL”, IIf(Mid([dbo_ppols]![policyno],4,2)="00","New Business","Renewal") IIF [DanPols Renewal].Term ="1" or "3" or "6" or "12" then Add the [ppols renewal].fee Basically If in the state of Alabama...
  11. AGoodGuy

    Access Query

    I have a query in Access 2007 called Renewal Offer Analysis and I have a table called State Policy Fees. I am trying to create a formula that will give me the policy fee added. For example: I have a policy in the state ALA (STATE) with a 6 month term (TERM) with a Renewal (Description) and a...
  12. AGoodGuy

    Formula in Access Query

    I have a query in Access 2007 and I have this below: =IF([Master Renewal Analysis].[Latest Renewal Notice Premium])>([Master Renewal Analysis].[Original Written Premium]),"Uprate", IF(([Master Renewal Analysis].[Latest Renewal Notice Premium])<])>([Master Renewal Analysis].[Original Written...

Part and Inventory Search

Back
Top