Summary: I am a bit of a beginner with access but am picking it up pretty quickly. I need to get my form to lookup a structure name and return it to a text box...
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: I have in a Table1 the Business Name Address and phone number and i Table2 i have only a phone number I want to delete into the table1 which is in the...
Summary: Our agency maintains a Paradox 9 security database. Within this database is table (with 1311 records) which contains demographic data for all employe...
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 using an several queries in an access 2003 database to track emails coming into various outlook/exchange folders. My problem is I have to manuall...
Summary: I have a perplexing problem with a Access/Word merge. The Word main document is connected to an Access query. Once the connection was established, t...
Summary: ery expression? Using Access 2003... I have a query setup to only output the following expression when certain conditions are met (so that only the wa...
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 print a daily report showing the production figures for each item. I now want to print, an accumulation of the production thus far. For example if I...
Summary: Overview: I have 3 queries searching 3 different tables for 2 fields. I then have one combining query that adds the results of the 2 fields from the ...
Summary: I'm new to Access & need some help summing fields from different tables. I have 3 tables: Table Fields Products: Prod Name, Opening stock Supplie...
Summary: Hello! Maybe someone can help me... I want to write procedure containing some queries as SQL query. For example, I have queries "sglstr", "sqlstr1" an...
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: Hi all, I need a help in MS SQL Express query. I have a table named "tblTotalCust" and the fields are: [Date] date, [ServedTime] date, [TotalCustomer]...
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: Hi, I'm new with creating Access 2003 db’s and have a question about inputting data. I have a list of equipment (32 pieces), equipment hour readings...
Summary: Hi I need an IIf statement to turn pupils marks into grades. for example all students scoring 0-10=F, 10-30=E, 30-50=D, 50-60=C, 60-80=B, 80-100=A I ...
Summary: I am working on a Microsoft Access project and need a validation rule for the job number. I need it in the form 09-140 where the 09 represents the cur...
Summary: My first try on a relational database! I created an Access 2003 database with two tables, linked by a one to many relationship. I created a form base...
Summary: Where are the names stored? Do you want the user to enter the data into a field, or into a form based on a query? Life's more painless for the brain...
Summary: Just did a search on Access 2003 and found several sites that are selling it for over $600. Why is so expensive to compared to Access 2007, which is s...
Summary: I try to include MS Access 2003 crosstab query design code (internally generated SQL) into a VB6 module. Here is the ColumnHeadings definition which ...
![[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
