Search results

Is it possible to write a query on a network table (not a computer network). For example: Streams flow into larger streams. Each stream has a nodeID at the top and bottom. So one stream from its headwater migh flow (simplisticly) from node 1 to 2, then from 2 to 3 and from 3 to 4. A second...

Sorry if this has already been answered. I searched and couldn't find it. How do I do an INTERSECT query in Access? It is my understanding that Access does not support the INTERSECT query. Is this right? The syntax for an INTERSECT query is: select field1, field2, … field_n from...

I have a "permit" table and a "permittype" table linked through a many-to-many join through "permit_permittype" Currently I have a form with an embedded subform that allows me to select multiple permit types for each permit and stores the info in "permit_permittype". There are over a hundred...

I am trying create a form that will list specific files in a specific directory. The directory contains multiple types of files (pdf, jpg, doc, etc...). All the files in the directory begin (first ten digits) with the recordID that corrosponds to the database recordID. So... when the form...

I have a form with a button that when pressed assigns a value to a variable (and it does other other things on the form). I would like to use that variable in a subform. Right now when I try to call it on the subform it is null. I am assuming that I have to make the variable public somehow...

Is it possible to count two groups at once in the same query? For example I would like to know the number of species and a count of species from the following simplified version of my database: sample (sampleID, lots_of_sample_information) fish (fishID, sampleID, species...

Is it possible to put an Autonumber field into a make table query? I am using an external application (ArcGIG 8.1) to access an Access database. I have put together a query that returns the table I need for ArcGIS but ArcGIS insists on creating a unique identifier in the table before it will...