I have a Query to generate a Report that is a form letter. I have a table
with a Name that is pulled by the query into the Report.  I have another
table with names and the company they are associated with. I have this table
so that if the Name has a Company the it will be added ...

Hello everyone, working with a database where I'm trying to produce a query
that will list all records that meet a certain condition.  Here is my SQL
...
SELECT Monitoring_Well_Data.SampleDate, Monitoring_Well_Data.Well

I posed this question a couple of days ago and got no response. Can someone
help.
I have a multiple user database that the user inputs data in through a form.
One question the form is: What is the name of your file saved on the

I'm trying to create a table using SQL in Access, but can't seem to
create a column with type Hyperlink.
I'm actually trying to do this via Delphi and using the TADOCommand
component to run SQL on the database.  It's all working well, apart

I have limited experience with Access and need assistance.
I have an shipment table that includes origin zip code, destination zip
code, and ship date.  I need to group all shipments that have the same ship
date and same origin-destination zip codes.  I need to also know how many ...

The calculated field in my query is DateDiff("d",Date(),[ExpirationDate]) and
the  parameter on this field (entered in the criteria section) is Between
[Low Value] and [High Value].  The results are incorrect when I run the query
yet when I replace low and high values with actual ...

Well the following query is not the one i will use but it's the same
prob :
SELECT sum(country_id ) , count( country_id )
FROM Tbl_Country, Tbl_config

Please can you help my query keeps saying it is too complex and i am not sure
how to get around the problem (not wanting to do more queries to supply me
with the daya i need)
Below I have showm my query

We have an Access 2000 Database with Duplicate records. These records have
unique identifiers for the individuals (person or company.
The database is a registry, where individuals can register different
products. The duplicates have typically been caused by incorrect data entry

I have the following query which i like to convert into a delete query and
use the command  
Dim StrDelete As String
DoCmd.RunSQL StrDelete

I need to create a query that selects data that is like one set of criteria
but not like that criteria along with others. This is so confusing to me that
I cannot even phrase the question properly. Here is an example:
Field1 like 'A' but not like 'A' and 'B' and 'C'

Can anyone help me with this:
I have a form with a subform and would like to change the colour of that
row/record that has been selected so the user can see which record they are
looking at easily.

I have already created a query of distinct rows.  In this same query, I need
the query to also return the rows ( the data includes an employee id) where
the employee id is found more than once.
Thanks

I currently have the following query:
SELECT dbo_myvDeltaT.jobnum, dbo_mytShortages.class
FROM dbo_myvDeltaT INNER JOIN dbo_mytShortages ON dbo_myvDeltaT.jobnum =
dbo_mytShortages.jobnum

i write the module function to get the output which
is as :
Sub MySecondConnection()
   Dim con1 As ADODB.Connection