Summary: Hi, I want to edit a query in Access using batch file. I am trying to edit a field[jobID] based on criteria. I want to open the query in design view...
Summary: I'm trying to design a query in Access that will find similar records (not dups). I have two tables with UserIDs. One is the result of a previous quer...
Summary: In the database window you shyould see Tables, Queries, Forms etc. Click Queries -> "Create new query in Design View", add both of your tables (the ke...
Summary: The specific steps will differ depending on exactly what you want to show. You will need to set the desired criteria for the appropriate field in your...
Summary: If the goal is to have all the data in one table, and your Customer Name is all one field (not recommended, but okay for now), make that the Primary K...
Summary: Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g. I h...
Summary: i'm trying to figure out the code to add an import-from-excel option that will place data in its correct fields as seen in the following pic of the ac...
Summary: I need a way to show a graph based table/query in MS Access form. I tried using OLE MS Graph and placed it in a form and then change rowsource to my ...
Summary: I am trying to create a search function in a form. it wil search the specified table and return the results in a subform on the same form. This is the...
Summary: Is there a shortcut key in MS Access 2000 for adding a new record? I haven't found one, and when I want to add new record in form view, I have to clic...
Summary: Sorry, I was'nt very clear. I have set up a macro with an import specification for a text file which has records for 4 fields, into a table. For ex...
Summary: I want to use macro in access to create a new column in several different tables. These columns shall consist of a prefix that I choose, typically "PM...
Summary: Message: I'm trying to do a program in Access to my husband clinic, I need first to check if the patient is male or female then if it is male I need ...
Summary: I have created an MS Access db, 2 of the fields relate to time...StartTime & EndTime. From this I have created a query to display the attendance time...
Summary: have to summarise something in ms-access. am using access 2003. i have a query with the following fields. (this query has some other fields also. this...
Summary: Yes it is definately possible. I have a similar thing on my access DB. I found out that it doesn't work in Tables, only on Forms. You need to place ...
Summary: Hello All, I work as a programmer for a direct mail company. Here is my problem: I am developing a Access (.mdb) database for a company that we just...
Summary: I am reporting daily performance data. I wish to compare weekday (M-F) data with Weekend (S,S) data. The actual date is called "TestDate". I create...
Summary: I've got a question about SQL query in MS Access, for example I have the following data: Table1: NAME ______ CITY ____ FAV vahid ______ NY ______ A va...
Summary: I have created a time card database that calculates total hours. Also, I have two tables employees and time cards. In the employee table all of their...
Summary: I created a database from data I inherited from another person. The data has three tables ' Mother, Child, Follow up Child data. The data on follow up...
Summary: I am a novice Access user. I am unable to get the answer from DLookup that I am expecting. Question: I just need to find out the minimum wage in e...
Summary: I am updating two fields in a sql server DB from a VB6 application. field2 updates fine but field1 is not updating at all. I tried the query in anal...
Summary: Could anyone tell me what this query would be like converted to Oracle? Thanks in advance. SELECT tblBlock.* FROM tblBlock INNER JOIN tlkpLocation ON ...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
