I have a select query that looks up from one table based on the users
parameter input.
when no data is returned i am presented with just a blank sheet. Is it
possible to display a msg box displaying "no record found" or somthing like

I need to use these two function in query and I don't know how.  Cuz I'm a
Newbie.  :)
Function CountCSWords(ByVal s) As Integer
'Counts the words in a string that are separated by commas.

I need to sort a query depending on what option is picked.  I have a label
report that uses a query.  The user uses a menu to pick different options.  
One option is to sort on last name, another is id.  I tried an iif in the
order by property of the report, but no sort atall took ...

For each record in a Customers table, there can be zero or more associated
records in an Orders table. I'm interested in the order numbers of the five
most recent orders for each customer. I'm trying to write a query that will
return the customer number and zero or more ...

I know how to use the unique records property in my query.  The problem is
that there may be one field that is different and this causes a duplication
in my list. There are 2 tables in the query.  I need to list all people who
are on committees in an organization.  When one ...

i need to convert values in one column in integer dtaa type to use in SQL
statment.
it seems both CAST or CONVERT wont work in JET.
How can I solve my problem?

Hi --
Where and how would I build an If-Then-Else statement in Access '97?
Thanks so much!

.I tried using Split in a query to split a delimited number into individual
segments and got an Undefined function 'split' in expression error.
Is Split invalid in SQL? If so, is there a cognate function that can be used
within SQL? I get really tired of using search & replace to ...

I am connected to a SQL file with a date field as a data type = 'LOCAL_TIME'.
It displays as an interger in my query. How do I convert it to a date the
users will understand? Time zone variable? Universal dates? Convert?

All,
I've got a table as follows:
[ItemNumber]    [Supplier1]    [Supplier2]    [Supplier3]    [Supplier4]
[Supplier5]

I have a simple Orders table that contains, among other things, customer
numbers, order numbers, and Item IDs:
CustNum, OrderNum, ItemID
12345, 08/22/2005, 546

I have two tables
1. With details of people
2. With events for these people
the events are two feilds Start date and end date. These tables are related

I would like to create a query that would display as follows:
Name         Company    Aug 2, 04    Dec 2, 05  Mar 14, 05
Doe, John    XYZ              Yes              No            Yes
Doe, Harry   ABC             No               No             Yes

I'm trying to create a query to summarize records based on dates.  In one
column, I want the sum of all expenditures before the beginning of the month,
in the other column I want the sum of all expenditures within the month.  I
think a union query is the way to go, but it's not ...

I created a Union query, pulling identical field names from both tables. But
how can I know which table the record is from? Is there a way to do this?
thanks in advance