I have a query on a database I imported from Excel, the datatbase shows all
the users we have and what access they have on a particular module.  In this
query I only care about the users with the same Y or N's.
 There are 25 columns (named:   add, modify, delete,etc) and 1900 rows ...

Im a little stuck doing a query.
In one of the tables the name of the user can be in any one of three fields,
and i have been asked to create a query where a popup appears to enter the
name of person to search for in each three fields. e.g. one popup for "auth

I am having a problem with a make table query expression that is relatively a
simple calculation.  The expression that is returning null is for Calc
Balance:
Calc Balance: IIf([tbl_CutoffImport]![END SCH BAL] Is Null,"0",((

I have two tables: Rugman and PDrive
The table look like this:
Rugman -- ID (Auto/key) / Number (text!) / location (text) / test (text)
PDrive -- ID (Auto/key) / Field1 (text!)

I only want to replace a certain character within a string.  Will the Replace
command do a substring search and replace? What happens if  some of the rows
contain the character that I am trying to replace and other row do not?  I am
trying to strip unprintable characters in the ...

Starting with this set of data,
Eff Date    Annual Revenue
07/04/07    $56,600,000.00
Can I design a query that would display the annual revenue spread out

Please assist.
I need a count of patient visits in the most 3 recent dates for each clinic
with the dates in separate columns.
I attempted to use a crosstab but I could not use top value feature in query

Hi Folks,
This should be very simple and I don't understand why it's giving me trouble.
I'm trying to delete records from a tbl whose field matches a "bookname"
specified in another 'exclusion' table.

I am using the Calculate working days function provided by Ken Getz and i
keep on getting data mismatch error when trying to run it.
both of the scource dates are in the medium format (all though i did need to
change on filed from the long format)

I need some help with an append query.  The date criteria is not
working in the append query, but it works fine when I change it to a
Select query.  Also, I can remove the problem Column in the RAD, or
just remove the critera in the column and the append query works fine.

friends,

SQL Server has a Go function with which you can have more than one statement
run after each other. like updating a field and then directly after that,
updating another field that refers back the the first updated field. Thus
having one statement instead of two.

I am trying to write a condition in my query using IIf statement and
the statement is quite long.
But I facing a problems that I am not able to type out all the
condition in the query.

I want to strip a 5 digit ZipCode from a string.
The string contains the City, State and either a 5 or 7 digit ZipCode.
Chicago IL 12345-7890
Chicago IL 12345

This seems too simple, but I just can't see how to do it. I need to query
for a date, any date. As long as MM/YY or MM/DD/YY or MM/DD/YYYY appears with
any date in a feild I need it to come up in a query. The dates are mixed into
a name feild. For example I'm currently also ...