Search results

HI All i have a Table named Payments Which contains payment details to employee in an year i can get total payments in year by Dcount Function but i want to get result in this table's Filed "Payment_No" that will shows no of payments till current payment.. giving more clearly as above EMPID...

Hi all i create an query in Access 2007 which is select query having many fields Like Pay1, Pay2, Pay3 Pay4 .....Pay 10 I want to create a field in this query which show sum of many fields like Pay 3+Pay4+Pay5+Pay6 How can i create and sum these pls give me help thanks in advance

thanks for rply please give me another solution for i want to use creteria from two or more text box i want to set as if textbox 1 is null then creteria is value of textbox2 or if both are null then creteria is value of textbox3 how can i do it pls give me solution

Hi .. i want to create a filter query in which fields are 1. Name 2. ID 3. Account My Form having Textbox is TxtAll i want to run query where Name or ID or Account Value is equal or like as TxtAll please tell me solotion soon

Please give me solotion

Hi minty thanks for give attention to my prob.. my code is DoCmd.RunSQL "UPDATE Salary2009toUpdate SET " & Me.Combo2 & "='" & Me.Text4 & "' Where Empid='" & Me.Combo0 & "'" and where bank='" & Bankname & "'" in this code ,, all variebles ( EMPID,Text4 and Bankname are Text Format. in some...

Hi All I Want to Create an Query to Find Diffrent Values in A Table/ Query Like Month Year Name School Post Jan 2012 Ankur School 1 Post 1 Feb 2012 Ankur School 1 Post 1 Mar 2012 Ankur...

Hi i want to result as dlookup function in access 2007 when i use dlookup like this =DLookUp("GPFDed","[SalaryAll]","[EMPID]='" & ![Cmb_EMPID] & "' And [SalMonth]='" & "Jan" & "' And [Salyear]='" & [me]![Label17].[Caption] & "'") it gives #Name? what is the problem and how can i change the...

thanks empid is text field feb is text field can i replace 2015 as Lebal caption value is yes how can

it is not working it shows #Error i placed 1 creteria as combo box value and second is name of month and third is year as 1st creteria is combo0 2nd is "feb" 3rd is "2015" how can i concatenate all of these creterias pls help me

i remove where but not working pls give me solution

hi pls give me solution how can i update fields of one table with update query where creteria are more than one 1 example DoCmd.RunSQL "UPDATE Salary2009toUpdate SET " & Me.Combo2 & "='" & Me.Text4 & "' Where Empid='" & Me.Combo0 & "'" and where bank='" & Bankname & "'" what is the...

i dont understand it pls give me code as Me.Text6 = DLookup("[" & Me.Combo2 & "]", "SalaryRural2009toUpdate", "Empid='" & Me.Combo0 & "' and salmonth= "& feb & " and salyear="&2015") it says >syntax error what is the error pls tell me and how can i solve it

hi all pls give me code for saving access database with date and time stamp when close database as database on 11:11am on 11082015 pls tell me how can i set it

i want to find a value from table on creteria creteria 1= text, creteria 2= year or number and creteria 3 = text pls give me solution

Hi pls tell me how can i set creteria in dlookup as =dlookup("Fieldname=1,Tablename=2,creteria1=3,creteria2=4 and creteria 3=5 pls help me i m new user of access 2007

data show in query but not in subform datasheet

i mean with not working is Subform height ,not resize as no of records

Hi i have a subform with year and month subform shows result of a select query , when i open query seperatly it show data as requred order but when i show data in subform releted to this query , data show in rearrange order how can i set order in subform as query reslut

Thanks CJ But it not working why i can't understand