Tables

How to type in file name and get notified if it is in a direct
It would just be adding the filename, not the contents so to speak. Basically a receiving department doing the scanning to make sure a matching file exists, if the file does not exist, the product must then be seperated and go to a different department to be processed into the actual graphic file that will the... 5 Jun 2008 16:50

How to type in file name and get notified if it is in a directory
We have a large database of graphic files. The file names match the barcodes we will be scanning with the exception of a pdf extension. We are using simple usb scanners to read the barcodes. I am wanting to be able to scan the barcode on the object and get notified (or at least create an exception report) of... 5 Jun 2008 16:19

Spec. field ... could refer to more than one table ...SQL Stat
The SQL from the Query? Or you will have to tell me where it is on the report. Thanks, Honey "KARL DEWEY" wrote: Post the FROM clause of your SQL statement. Better still post the complete SQL. -- KARL DEWEY Build a little - Test a little "Honey" wrote: I have to track 4 gene... 6 Jun 2008 15:54

Spec. field ... could refer to more than one table ...SQL Statemen
I have to track 4 generations of pedigree for horses. I created a pedigree query using self joins by copying the Horses table and joining the sire and dam id fields to the Horse ID field in the copied tables. I have changed the name of the copied tables and everything seems to work just fine. I created anoth... 5 Jun 2008 14:46

Not statement
I have a query and need to exclude some'SKU" items. If I enter just one exclusion it wil work but when trying to enter more than one it doesn't. I know I have done this before but this time I'm stumped. I want to do this in the SKU field: Not B008 or 365* or I* What am I missing?? Thanks! ... 5 Jun 2008 15:48

Key violation problem when i import the text file
Hi: I create a table with 5 field without any records, and i want to import a text file to update the table. I have a field "ID" which is primary key for the table, i set it to be "autonumber". When i import the external file, it says "error due to key violation".and only a few records can be imported to t... 6 Jun 2008 19:59

IIF calculation
I have a query that is calculating royalty for book and cd sales. My royalty field is currently =Sales*.2. This gives me the dollar value for the royalty on sales. I need the royalty field to also do this: IIF 'SKU' =B* then Sales*.2 or IIF 'SKU =C then Sales*.1. Thanks! ... 5 Jun 2008 13:44

Making a 1-1 database usable for future projects
I have created a database to manage the process of recruitment for a project. Currently all the details of the applications are recorded in one very large table and I'm using autonumbers for the primary key. The personal and contact details of the applicant are displayed on one form. The details relating spe... 5 Jun 2008 03:26

Design assistance - Employee history
Hi all, I have a question about a table and relationship design. I am building a Task management system for my current workplace (well an upgrade of an older version). I think that I have the tables well developed and they seem to be working well for the actual task management. Each task is assigned to a posit... 6 Jun 2008 06:40

How to Delete Blank Spaces in a Field?
I import a Foxpro DBF table APCHK from our accounting system. Table APCHK has a text field for CheckNumber. Field is 8 characters in length and is any combination of Alpha and numeric. The values appear to have leading blank spaces ---- meaning if the value has 5 characters there are 3 blank spaces and if th... 5 Jun 2008 00:22