I have a table that I need to query to pull out all account numbers that have
the characters 921 as the 11th, 12th and 13th character.  The table has
90,000+ records a sampling of the format of the account numbers are:
123456789-921-1

What function convert text value to numeric value
I want to sum 2 column in query
Cloumn1          column2
1                                  2

I have a union query that joins tables that have memo fields.  I saw help in
the Discussion Group that suggested using Union All to get all the characters
in the query.  It works fine for the query (I see all the characters in the
memo field in the datasheet), but it bombs the ...

Good Day,
For your consideration I have the following question.
I have a process that leads to the below dataset.
Name           Start Date          End Date      

words I have seen way too much of today! And if it is not "too compex" then I
get a message saying "insufficient resources".
I have spent the day trying to break up boards into smaller sections and
trying to find other ways to get the same answer.  Eventually I have to bring

I am sure in Access V2 - 95 that if you used made a query (with an order by
clause), then used that query as a sub-query to select the first record from
a grouping withing the subquery, that you would get the correct record. In
Access 2003 however, the agregate query seems to ...

I need to find the third record in a query.  This is my basic select query:
SELECT tblGuests.GID, tblGuests.Date
FROM tblGuests
ORDER BY tblGuests.GID, tblGuests.Date;

Each month, I enter by date, a specific type of income, ie: sales, cash
donations, etc. Currently when I enter the desired time period, January 1
through January 31, 2008, I receive a total for each type of income for each
date. For example if I  entered on 25 cash donations on ...

I am trying to combine two tables into one but when I try to combine
the text fields it gives me null values
Table A
Customer          SalesPerson           TEXT             TEXT2

Hi, I am trying to get results in a query using the between two dates.  (ie
between 1/1/2008 and 1/31/2008)  The date is formated in date plus time.  (ie
1/31/2008 10:27:16 AM)  Everytime I try to get the dates for Jan for some
reason 1/31/2008 will not come up in the results.  I ...

On my form, I need to put a button to run a query. When using the toolbox in
the Design View, I use the Command Button Toolbar, then use Miscellaneous,
then Run Query. I select the correct one, and save it to the form. When I try
to use it, I get an error message, and it will not ...

I am trying to combine two tables but when i get to a text field it
returns a null value.  Is there any way to get the query to return how
I want it?
Table 1

I have some ADO statements in my code (INSERT, UPDATE, DELETE) used in a
passthorugh fashion, like
   .
   .

I know this is going to seem very vague.
For some reason my query that is accessing a table is not using the criteria
that I've given it. I'm hoping you can help me with WHY.  
The Course_Code is a text field. It's very simple.

I want to  be able to do the following :
I want to know if a customer has bought something within a predefined
period, starting from a varying date.  My data are recorded in table tblA.
E.g. :