Here are the pertinent tables and fields
Author
======
AuthorID            AutoNumber - primary key

In my library database, I built a query to search for books by title.
Unfortunately, you have to type the whole title or the FIRST WORD * to get
any results.
Here's what I'd like: If I'm looking for the book "My Dog Skip", I want that

How can I use in a query in design view in criteria a variable (A variable
used in VBA code)?

What is the Access SQL syntax for comparing only the date portion of two date
time fields?
Branden

I have a table that contains the following field and data for loan
payments:
ClientID, 56898
FirstPaymentDate, 05/23/04

Is it possible to number rows in a query up to a certain number, then begin
the numbering sequence again. For example: The original table currently looks
something like.
TitleName

I have three date fields, EffectiveDate, DisconnectDate, and SuspendDate.  I
want to create a status field where the result will be Active, Inactive, or
Suspended based on whether there is a date in the field.  What is the SQL
Statement needed to accomplish this in an Access ...

I would like access to list the values between that range. Those are the only
two pieces of info I have 000001 and 007893

Hi, I'm trying to develop a query in which a user would have to input just
one date, and it will return records that are either equal or less than this
date.  Access seems to want to pull records matching that date EXACTLY, and I
don't want that to happen.  I also do not need to ...

Hi again,
Alright, I've been playing around with the SQL code, and I think I'm close,
but I can't seem to get over the hump.
I found an example is using a SELECT statement in the FROM clause of the SQL

Hi.  I am running Access 2003 under Windows XP.  I have a crazy looking
output file that I need to analyze.  The system we are working with creates
output files that can run 3,000 - 35,000 rows long by two columns wide.  Of
these rows, maybe a few hundred are relevant to our ...

I'm trying to run a query which includes a table with a Memo field.
Query won't even run but giving me this error:
"The field is too small to accept the amount of data you attemted to add.
Try inserting or pasting less data"

Would anyone be able to let me know if there is some function or
multiple functions that will allow me to obtain the serial dates of
the last day of the previous year and the first day of the next year
based on a date field called [CurrentYear]

I'm using a parameter query and it seems to be saving previous queries. For
example, if I want to find records with A in a particular field, it will find
it ok. If I search for records with A and B in a particular field it will
bring up only records with A in them (hope this make ...

I'm trying figure out a query or series of queries to give me data on units
we collected rent on more than once in a month. To help explain this a
little better we rent storage units. Now we prorate (charge by the day) the
first months rent, but after that we charge for full ...