I've set up a user interface to allow users to click a button to search our
customer database by surname - this brings up a popup asking them to enter
the first few letters of surname, but I also want to include another search
where the user clicks a button to search the customer ...

Got a question that has been bugging me for days and need a bit of
inspriation. The data I have is this:
Material : 123
Date: 1/1/05

I am working on a school database. One of the tables contains a list of
pupils and the teaching groups that they belong to. In order to a.ses their
progress we need to enter data regarding the level they are working at. I
need to be able to present all of the pupils in a ...

I have the following query:
   SELECT Format([price],"0.000000000000000") AS Expr1
   FROM table1;
anything works fine !!!

I have a Update query in MS-Access which when run prompts for a parameter
and then copies data from TableA to a Temp Table.
As I need the Query to run more than once using a macro or code,  how do I
pass a parameter once so that if the query runs more than once it does not

I create a button to open the query using Form screen.  After selecting
Active Group from the combo list, one of the query works but other query
doesn't work because of Crosstab.
Can you help me how to set this up?

I have a sales records table with the following fields - FiscMonth, CustNo,
Product, SalesQuan, SalesVal, ShipDate.
One of our customers would like their sales data summarised as follows -
Product, Tot Jan Sales, Tot Feb Sales, Total Mar Sales etc., YTD Sales,

On 06 July I had posted a question to the forms coding DG asking about an
"Unspecified Error" message that I was receiving in processing a NotInList
event for a combo box. The action query involved the use of a nested select
to obtain one of the values from another table. I found ...

Hi,
I have a crosstab querey that when I run it, dispays the columns
alphabetically from left to right (the field names are letters W, L, D). Is
there a way I can set the order the columns appear in when the querey is run?

How do I do two left join:
Select *
From Order
Left Join Emp.ID  on Emp.ID = Order.StaffID

I have a SQL query that make a table with a very long text on one column.
When I run the query without making the table the text is complete, but when
I Make the Table the field appear truncated to 255 characters.
I need to keep that column as a Memo not as a text, so all the ...

I posted this problem several days ago, and tried the suggestions but still
can't get it to work.  Here was the original posting:
I have two access 2003 tables.  One is Client and contains name, index#, and
age... The other is HistoryOfWhoClientDated and contains index# of client ...

This query is a little obnoxious so I'll be appreciative if somebody wants to
dive in and equally unsurprised if nobody does.  
Basically, I have a series of queries built off of one another.  The first
query gathers fields from about 5 tables... 4 of these are ODBC linked tables

I'm trying to build a query that list all the customers  who bought a certain
product last year but not this year.  
I know how to pull all the customers who bought the product after 1/1/4, but
I don't know how to weed out customers who bought the product last year and

I am trying to count the number of consecutive days a client stays in
serivces.  My variables are: client number and a service date.
Thanks