I need to identify a short date field that has not had a date entered into it.
Tried creteria ="Nul" but this doesn't work.

I've got criteria in my query to be based off a combo box of my startup form
which is linked to a table. It works fine, but how can I make it so it won't
use any criteria and display all records. My table has two columns, the first
is what is used for criteria, I thought if I made a ...

I am using Like to search for certain text and Replace to replace it with
some other text.  Example:
Like "*(*" Or Like "*)*"
Replace(Replace([Data]!CODE,"(","["),")","]")

I would like to create a query that contains an IN clause whose elements are
determined by the value of a parameter:
PARAMETERS VariableIDs ???;
SELECT a.ID, a.VariableID, a.ExecutionIndex, a.ExecutionCondition,

I'm trying to extract certain information from a column and I can't seem to
do it. This column is called information and it contains a description for
each row . Within the description there is a number like BO1589. currently, I
have about 4000 rows. Each number will repeat or will ...

I have two tables. One has "customer full name" in one field. The other  is
from another database and has two fields, : "first name" and "last name". I
want to retrieve all records that match :customer full name" in one table
with "first and last name" in other table. I don't ...

I have two tables. One has "customer full name" in one field. The other  is
from another database and has two fields, : "first name" and "last name". I
want to retrieve all records that match :customer full name" in one table
with "first and last name" in other table. I don't ...

I have a Report that runs fine, but the query will not "run" by itself.
Any ideas out there.
Thanks,
Blaze

Is there a way to query a memo field to find out which record in the database
contains the most text in the memo field?
TIA

I have multiple tables that have the same fields. For instance, I have five
tables that have the following fields: firstName, LastName, TelephoneNumber.
I would like to create a query that has will list all of the records in the
five tables with the column headings firstName, ...

I have two tables. One has "customer full name" in one field. The other  is
from another database and has two fields, : "first name" and "last name". I
want to retrieve all records that match :customer full name" in one table
with "first and last name" in other table. I don't ...

I have months (MMM-YYYY) in the columns in the crosstab query.  I need to
sort them according to time and not alpahnumeric.  With MMM-YYYY formt they
are listed ini alphabetical order, so Apr-2005 appears before Oct-2004.  Any
ideas how to accomplish this?

I am triying to use condition wtih some fields in the FROM clause of an
Access query. But I get an error saying that "the conbination expresion is
not valid".
I know that this kind of sintax is valid in SQL Server but I ignore if there

I am new to SQL and need help in extracting some data from a table
My table has the following data -
FUND_ID        BEGIN_DATE    END_DATE    FEE
50        19910101    19930830    0.5

I made a form with a button that generates a report based on the info that
the user puts in the form. The record source of the report is a query that
composed of a union of select statements. Im testing two fields in the form:
company name and document year. When i input the ...