Search results

In Table named MAIN i store the data of the members No, Tank, Name_, Barcode in ENTERKOT i store Date, Barcode This is used to ckeck how many times and when these people entered the premisis of the store. so that when a person show the barcode in front of the scanner the barciode should...

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 added INTO USTATE and it got saved to the new table now the problem is when i run the query it takes only 30 seconds to calculate and display but when i use INTO USTATE it takes 4-7 minutes to get finished and asks if i want to delete the existing how can override both problems

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

YES i agree with your suggestion. how can it be done

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

i know about linking but when u look to my two tables and the structure and my requirement. Then the linking is not the solution. I am willing to count COY(field) from PERS table and update the count number in HELD (field) in front of that COY in authpers table.

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