I am looking to be able to run a report that shows who has not paid their
bill for the month.  I have a paydate field that I want to search in and I
want to show the people who have NOT paid or the ones that do NOT have a
record in this paydate field between two dates.  And I ...

I have a field called birthdate that I have formatted for long date so when
the user inputs the date as 8/21/1999 the month name August will appear in
the field also.  I want to be able to serach for all birthdays in a month but
when I set the search criteria in my query to ...

I'm being having trouble setting up an update query that would help me update
the amount field on my report to zero filled the space.  
For example:
Amount     Want to be

I would like to expand this query to be B followed by any 2 numbers, for
example B01, B99, etc.
Mid([description], InStr([description], "B45") + 1)
Thank you

In my table, I have a date column and I also have a time column.  I need
to join these into one date-time field so that I can do some time
comparisons.  How can I join these two into one column?
Any help is appreciated!

I posted previous on this but did not really get a response.
I have many tables with different fields and some fields are the same.
What I need to do is find an average of how many entries a processor entered
and how many corrections they had within a date range and than calculate ...

I've got a problem to make a query. Here is a sketch of the situation.
There are two tables: in the first one there are people with a number.
In the second one there are activities that can be done planned on 3 times,
with the number of the people who are comming to the activeties.

Conceptually, I understand what needs to be happen, but technically, I don’t
really know how to do it.  Here is my Select statement:
SELECT tblEvents.Event, tblPubs.Name, tblPubs.Address, tblPubs.City,
tblPubs.State, tblPubs.OnDate FROM tblPubs INNER JOIN tblEvents ON

I have a table containing three fields, LastName, FirstName, AdmitDate.  I
want to write a query that will figure the HPDate which is the AdmitDate plus
3 days.

kindly help me in this.
I have created 2 tables d1,d2
d1 fields are x1,x2;  
d2 fields are y1,y2;

I have a main table with several fields for people - i.e. Engineering, CAD,
Manager, etc. The fields contain a number to represent an individual. A
separate table has, as its "key", the number identifying the individual along
with the name of the person. This table contains all ...

I want the comma to appear ONLY when there is an appartment address AND a
street address.  I can't seem to get rid of the comma when there is only a
street address.  I have tried to adapt what I have read on Discussions, but
have not been successful.

how to join the following two cross tab queries by SQL? pl s help
TRANSFORM Avg([current year].SumOfPAID_AMT) AS AvgOfSumOfPAID_AMT
SELECT [current year].OCITY
FROM [current year]

I just want to make my query to look in the memo field name "Note1", the
records that has a content of "Jatimulia", but it seems it can not work.
Anyone can help me?.
This is my query:

I created a query in my database based on the values in a (Yes/No)field. In
order to display the records I need, I inserted in the 'Criteria' line the
following [For Condition1 insert '-1', for Condition2 insert '0']. How can I
make these '0' and '-1' a little more user friendly. ...