|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 27th, 2004, 02:10 PM
|
|||
|
|||
simple query not working-urgent please
SELECT Sum([Sales temp].Sales) AS Sales, Date()-1
FROM [Sales temp] HAVING ([Sales temp]![item] Not in ("25773621","afy04890)); It gives me a "type mismatch error" Thanks 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
| Crosstab Query -- Urgent!! Help needed....... | bpan007 | Setting Up & Running Reports | 1 | July 13th, 2004 04:50 PM |
| Hidden files in Ms-Query cause ODBC connect errors or Query is wac | needyourhelp | General Discussion | 4 | July 12th, 2004 09:38 PM |
| query field reference help | -dch | Running & Setting Up Queries | 4 | June 2nd, 2004 07:30 PM |
Threaded Mode