I've got a simple database used to schedule deliveries which contains one
main table of orders.  The 2 main fields are the scheduled delivery date
(scheduled) and order value (value).  I need to present the user with a
running total for both number of orders and order value that ...

Hi, I have a description field in a table that contains both numbers and
text.  I wrote a query with Like "*#*" in the criteria for that field so I
know that all rows returned have at least one number in that field.  
Now I would like to return the first number in that field.  For ...

I am trying to retrieve to Excel a query from Access; that query got a
date field I am capping with a criteria like this
<=DMax("Week","Tbl_Data) because I need only records up to the latest
date from that table. In Access all works well.

I am learning how create pass through queries and am currently working on
converting a query I had created using the design mode to a pass through
query.  The query I created using the design mode reads a table made from a
previous query.  The make table is stored in the Access ...

When I run a query, I would like the parameter to use a combo box from one of
the tables I created.  I do not want to have to type in the information
because some of the selections are abbreviated and/or long and it would
require everyone using the query to type in the ...

I have a table with 1500 records (one record for each part number) and it is
25 fields wide. Each field is for a product but every field is not populated
for each record. I need help with QUERY to use for reporting how many
products (fields) use (are populated with) a certain ...

How can I add a carriage return to the end of text? Example:
update addendum set text_data = ([textdata] + _____)  
What would I put in the space _____ to get a carriage return here?
Thanks for any help!

I have a table with unicode (Greek) text in it which I imported from a text
file.  When I view the data I can see all the correct unicode characters
correctly.
I then did a distinct query, and I am missing a lot of my data - in fact, I

What does this expression do in the query? Thanks
BLANK-C" Or Is Null

I have an access 2000 app that I am creating a subform. This subform has data
from two tables:
BidHistory
--------------

I want to find out how to clear a query on a Access 2002 database.  The books
say there should be a option in edit menu but it is not there.

I've inherited a rather complex database that hasn't been written using
normal form or thinking about data redundancy.
What i've got is a form that makes data entry a pain and increases the
length of time required to keep things up to date.  What I want to do is sort

Dear gurus,
Using a Query how can I get the decimal part of a real number? i.e 123.34 to
show only 34.
Thanks in advance.

How do I get my query from orders table to list orders for a period of time.
Like from 10-23-06 to 10-27-06.
I would like to make a form to ask me to fill in the dates from _____ to_____
of orders to include on my weekly sales report.  

I'm trying to use forms to allow a user to select multiple parameters
to execute a query on the "front end". For this example let's say we
are querying, choosing options from three different combo boxes that
link to a query. I want to be able to choose from two of the combo box