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: 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: 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'm trying a small database program using MS Access 2003. I have a number of tables ( 5 in number ) as one side related to a single table as a many si...
Summary: Hi, I have a MS-Access 2003 database. I modified the properties of one of the tables(added name description). After that, the reports using this table...
Summary: I have read a few of the responses here, and am impressed with the replies. In that regard I'd like to ask this question. I am attempting to implemen...
Summary: I had MS Access 2.0 for a long time. Then I got MS Access 2000. There's one thing that bugs me about the newer version: when moving between a form's f...
Summary: Hello, I have created a database in MS Access that has multiple forms in order to help my co-workers enter "invoices" for our customers and to keep up...
Summary: How to create a function in MS Access?Pls help!! ---------------------- Hello, I need create a function in MS access 2003 which run a ***.bat file in...
Summary: Hi, I'm trying to run a query similar to the following: Select category, count(distinct names) from tableA AA inner join tableB as BB on AA.ctr#=bb.c...
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 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: Hi, I'm having an issue trying to match up records I have in an Access table. Each time I append the data to the table, it creates duplicates. It does...
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 have a db designed using MS Access that I would like to distribute to my friends. But I want to make sure that they cannot change VB coding. How do ...
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 ...
Summary: I am trying to export a single record from an MS Access 2000 database to an html template. Is there a way to do this without having to do a lot of pro...
Summary: INSERT INTO [table] ([column1], [column2],....) VALUES ('value1', 'value2',...) Note: those brackets don't denote optionally; it's how MS Access forma...
Summary: I need to perfrom calculation at the lowest level in a product hierarchy and then roll up the result without recalculating at higher levels. How this ...
Summary: I have an old DOS program that saves data to a .dbf database file. I would now like to add data to the .dbf file through MS Access. I have successfu...
Summary: I am using MS Access. I have a query built off of 2 tables. The data is 100% correct. I can't seem to run a report that is correct. I need to create...
Summary: I can create a drop list to use in a table, form and report. I'd like this same functionality when I run a parameter query. Instead of typing the para...
![[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
