Search results for query: *

Hi, with my query, it is inserting all the data from bilact table to my temptable tblCurrent_Month. But I just need to insert the data where the month of Bcr_Billing_period. Ie I give 01/23/2006 it needs to pick the data where Bcr_Billing_Period is between 01/01/2006 to 01/31/2006. My data for...

Hello All, I need to validate State and ZipCode. I will have to extract all the data where is there is data mismatch between state and zipcode in my table elgadr. The fields in elgadr are for state: erstat for zipcode: erzpcd and data shows like erstat erzpcd CA 95682 To handle...

Hi All, Someone please help me. I wrote a query to extract the members where Child DOB is older than parent. It runs really quick but it is returning duplicate rows. Please help. My Query: SELECT DistinctROW elgdep.MEM_SOC_SEC_NUM, elgdep.MEM_DEP_CODE, elgdep.MEM_EFFEC_DATE...

Hello, I have to pull in the records which has state and zip mismatch. For this i created two tables state and zip. State with State_ID,State_Code,State_name Zip with State_ID,Zip Where State_ID is primary key and Autogenerated. Could someone give me the logic about how do i validate...this...

Hello, When i run my report, every alternate page is printing blank...how do i remove blank pages..someone please help

Hello All, I need to pull the records where the location starts with 'z' or 'y'. Here is my query SELECT elgemp.ENR_GRP_NUMBER FROM elgemp WHERE (((elgemp.ENR_LOC) Like 'Y*' Or (elgemp.ENR_LOC) Like 'Z*')) ORDER BY elgemp.ENR_GRP_NUMBER; Is this right method? I dont get any records when i run...

Hello All, Thanks for the wonderful responses and i am beginning to learn Access now :-) Here, I need to pull all the members who have more than 110 years of age as of today's date using Access 97 Here is my Query: SELECT elgdep.MEM_SOC_SEC_NUM, elgdep.MEM_DEP_CODE, elgdep.MEM_BIRTH_DATE...

Hello All, Could anyone give me the syntax for Date convertion in MS Access 97? Thanks

Hello, I am using MS Access 97. I need to pull out the records which has effective date more than 6 months from todays date.. i wrote my query as follows SELECT elgdep.MEM_SOC_SEC_NUM, elgdep.MEM_DEP_CODE, elgdep.MEM_BIRTH_DATE, elgdep.MEM_EFFEC_DATE FROM elgdep WHERE...

Hello All, I am a beginner in MSAccess and have this prob with my query. I have to pull in all the members who have their DOB in Future and i wrote this query. It works but it takes forever to run the query. I dont understand why its taking so long to run the query, i am using Access 97. Before...

Hello All, I am a beginner in MS ACCESS and i have a very tight deadline assignment to work on. Someone please help. I have to pull out the members who have their Effective Date more than six months from the given date. This is the query i wrote, but i get an error "This expression is typed...