Search results

Sir, i am new in MS Access i had worked in asp.net. but now i want some help in access. I have a small accessd database in which i have a form there is abarcode field when barcode is fired to that barcode filed a query should run to fetch the data of that particular person from table named MAIN...

i have a count and store data INTO a table named USTATE when i run the query it works within 30 seconds. but when i add INTO USTATE then it takes 4-8 minutes to complete it and asks for if i want to delete the existing how can i solve both problem

i have a query it correctly displays output as i require. i want to update/store the output query to a table named ustate. my query is as under SELECT Auth.nit, UC+UL+UC AS Aut, (select count(NO) from Pers where nit=Auth.nit and rOrd>4) AS Present, (SELECT COUNT(no) FROM pers WHERE nitFrom =...

i have a access table (AUTH) with following field Company Auth Held Tata 12 Dell 11 HP 21 Opera 11 Bangour 10 i used the following query to calculate the Held from a table named pers. SELECT AUTH.company, AUTH.Auth...

there is a query which i made which counts data from two tables RAUTH AND PERS SELECT RAUTH.coy, RAUTH.Auth, Count(RAUTH.coy) AS Held FROM pers INNER JOIN RAUTH ON pers.coy = RAUTH.coy GROUP BY RAUTH.coy, RAUTH.Auth; THERE IS A BLANK FIELD NAMED HELD in table RAUTH i want to update the held...

i have two access databases one name wing.mdb and another is pooja.mdb common field in both is PNO already there is data in baiju (table name in pooja.mdb(database) and blank field named qual and rec There is a table named Mqual(table) in wing.mdb(database) with PNO, qual, grading...