I hope this is possible.
I would like to create a query which will allow me to have a prompt for a
key word which will be looked up in a memo field of a table and bring up
a/many records which contain that word amoung the sentences/phrases in the

Hi I have done the dateserial(left([date},4),Mid([date],6,2),Right([date],2))
which seems to have worked fine, except it will not let me format the date
all it returns is 01-Jan-06 etc..  So when I go to do a date parameter it
does not restrict to what I am asking for in the ...

I'm attempting to write a simple CREATE PROCEDURE statement (in anticipation
of more complex ones later), eg.:
CREATE PROCEDURE proc1 AS SELECT guild_cd FROM guild;
No matter how I structure the statement, I get the error message 'Syntax

I am currently projecting a date in a query that is 30 days prior to the
field [Start Date] using this formula: DateSerial(Year([Start Date]),Month(
[Start Date]),Day([Start Date])-30)
I would like to project 30 business days prior instead.  I found the

Currently in access with a transform query, all subqueries cannot have field
name variables.
Please Fix.
----------------

I have some reports that I need to be able to save the file name
dependent of the value of a field in in the parameter query.
ie.. field name [XCOP] has a 3 (parameter query value) file name is
"Gro3" The file would export as a delimited file.

I would like to query a database and add the values in a string of XML in a
particular field. Is there any way to do this using SQL?

I have a huge amount of data in a table. These are times taken to fly
somewhere.
I want to group this data by month and year, and for each month I want to
consider all the flight times in ascending order of duration. From this I

sI have a database that records people and donations they make over time.
There are two table 1. Donors (with fields: ID, last name, first name) and 2.
Donations (with fields: ID, gift date, gift amount) I want to be able to
calculate the total number of first time donors per ...

I am trying to count a sorted number field in a query. For each identical
number I want the count to increment by one.
For example
Number   Count

I have set up a database to record staff sickness, and I would like to
create a query that pulls out records where the staff member has 3 or more
occurences i.e. a query that retrevies records where the staff member appears
3 times.

I am doing a re-attack on a message I posted her a couple of weeks ago.  I'm
still trying to make this query work but no luck.  I have tried every
combination I can think of to get this query to run.  What I currently have
is:

When using Count in the Total field of a query, if there aren't any records
that match the specified criteria, how do I get the query to return a value
of 0, rather than just not including a record at all?

I have a query that sums qty sold by item and by class within a date range.  
I want to create a second query that sums the date by month and year.  I've
try formatting the date but no luck.  My gaol is to get the data in a format
that I can filter on month and year.

I have two queries -- the first is a query that has no tables, but
references two control values on a form:
Query1 TDATE:
SELECT Trim([FORMS]![CONSOLIDATED PLAN REPORT LIBRARY]![CFYEAR]) AS