In Access 2003, we have run into a problem with binary field types when using
make table queries. It occurs when we want specific data in a table to be set
later with an update query.  To do this, we leave the parameter blank in the
make table query, or fill it with the word ...

I have created following query.. but i would like to know how we can use %%
with the [Keyword] variable at where clause. I tried %[Keyword]% but its
giving me error.
PARAMETERS KeyWord Text ( 255 );

My Table has duplicated rows for each item. I need to derive a query list
from the Table that represents each item only once or only one of the rows
representing each item . I’ve tried [unique only], *unique*, *unique number*,
and every possible variation from these. All I get is ...

Hi I have a basic query
I wish to look up an invoice number in a table and for it to return the date
value,
table 1 invoice range

I hope someone can shed some light on this problem I am having.
I am quering a database that has  5794 records, and when I use the LIKE
syntax I will get back X number of records, when I use the NOT LIKE syntax
with the same LIKE value, the return is not what I expected (i.e.:  ...

I have a table with 2 columns both links to other tables containing
descriptions for the ids. I need a query to provide a recordsource for a form
that returns the 2 columns of the table (not the descriptions) but sorted by
the descriptions instead of the codes. Any ideas?

I used a crosstable query to combine information.  I need to know how to
combine all date groups of the same date.  I may have two or three fields of
5/05/05, however I want one set of information.  Here is an example...
I want this:

This may have been already answered.  I have a table that consists of 30
fields.   These fields have dates as column headings.  The other column(s)
have a customer field, and a check box indicating if a payment is promised.  
In a query, I would like to only see those customers ...

I am trying to create a query that will join 2 tables together when they
have the same first and last name and same Date Of Birth....however the one
table is from a different database and it is in the following format:
If the date of birth was 12011972 the database shows it as ...

I got a problem with this query, it always come out 1 record but it's
include the other record with diffrent case_no ID. For example I search case
number=20==> the result is:
caseno1 mon_ltr_sent mon_ltr_rtn   caseno2 inv_ltr_sent inv_ltr_rtn

Hi.  I have a query which selects data from 1 table.  The query produces the
following result...
ID   Station      Amount
1    Receiving   54

I have a database with the following fields:
Date    Volume
Specifically, I am trying to write a query that will select the record
(Volume) if it is the highest in the last three months.  

I feel really dumb that I can't get this to work, but here goes!
A dialog box filters a report by way of a query.  The underlying table has a
yes/no field which I need to include in the filter.  For some reason, no
matter what I do, it returns all records instead of "yes" or "no". ...

   I would like to know if anyone can point me to a good place to learn
about date type functions, queries etc... for MS Access.
I am trying to build an update query that is on BirthMonth.  In the query I
have placed the following fields from two tables

I am having a difficult time trying to write a query that will display
different outputs depending on what is listing in the text box.  For example
I have a table that lists hundreds of platter logs and I am trying to write a
query that will give me the tranlog for each platter ...