Search results for query: *

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...

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...

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?

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...

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...

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?

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?

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?

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.

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...

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...

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...