Search results for query: *

I have this SQL statement.... SELECT TOP 5 table1.myvalue AS myvalue223 FROM table1 WHERE table1.appdate<#6/10/2004# ORDER BY table1.appdate; But is returns more then the top 5, if I remove the order by statement it works fine. What am I doing wrong? Please HELP I'm really in a jam! thank you!!!!

HEllo, I have a non-binding form with a text box. I put =(SELECT sum([table1]![field1]) FROM table1;) as my control source but all I get is "name?" What's wrong and how can I get this to work?

When I use the DoCmd.TransferSpreadsheet acExport, , "myquery", strpath, True, "" The numbers get cutoff. The table will show.... [Field1] 12.1299 12.1546 10.1558 but the exported file in .CSV format only exports... 12.12 12.15 10.15 What could cause such a weird thing and HOW can I fix it...

The challenge is this. You have data in a table with two fields "appdate" and "text" [appdate] [text] 1/1/2004 DTD 1/1/2004 MTD 1/30/2004 DTD 1/30/2004 MTD 1/31/2004 DTD 1/31/2004 MTD 2/5/2004 DTD 2/5/2004 MTD 2/29/2004 DTD 2/29/2004 MTD The goal is to...

When I use the DoCmd.TransferSpreadsheet acExport, , "myquery", strpath, True, "" I get an extra apostrophe in front of some fields. I'm not sure why. The particular fields are text fields, does that matter? How can I get rid of the extra apostrophe? I get... 'mystring 'mystring1...

This is the challenge. I'm not able to do it, but some of you might me able to. Using SQL to group dependent on date differences. For example try to group all items that are within 5 days of each other in the same group. e.g. raw data date value 1/1/04 1 1/2/04 1 1/4/04 1...

I'm trying to run this sql code, but I get an error "Insert into tbl_Trade_Orders_allocated SELECT *," & Chr(34) & Now() & Chr(34) & " FROM tbl_Trade_Orders WHERE [Trade_group_ID]=" & intTrade_group_ID & ";" "Run-time error '3352' No destination field name in INSERT INTO STATEMENT...

I'm still having some problems with my sql, it stated to few parameters. I have on extra field called "ID" and it is an autonumber. How can I fix this? mysql = "INSERT into tbl_trade_orders([txndate], [txncode], [symbol], [quantity], [price], [commission_per_share], [broker]) values(" &...

I have a sub, that inserts sql values into my table, the table has an autonumber and I'm not sure how to insert values with an autonumber. I keep getting a syntax error. The table has id,txndate,txncode,synbol, etc. etc. but the autonumber is the "ID" field. Please help. What is wrong with my...

I have XP professional and a mac OS X 10.3. I'm trying to copy my files from my windows XP machine to my local drive(Macintosh OS X 10.3). I can see the local drive under "My computer" but I can not copy from my C:(XP) to my local disk(OS X). I get a message "Can not Copy: Cannot read from...

I'm trying to use.... print.debug "Hello" but I don't see anything apear on the screen. Isn't a box saying "Hello" suppose to appear? Is it some thing I'm doing that could prevent the message from appearing?

I am making a pivot table and I would like a custom grand total. But I'm not sure how to do it. I would like to use =exp(sum(log(1+[field])))-1 instead of the standard sum of [field] I don't know how to set it up, or if it is possible. Does any one know? THANKS

How do you export a graph from report to MS EXCEL? When I try to export the graph all I get is a blank excel document. What am I doing wrong?

I am using the below if statement, but it does not seem work. When it processes the statement below it goes to the if else and does NOT process &quot;do this&quot;. Any Ideas? ___________________________________________ dim test1 as string dim test2 as string test1=&quot;2&quot; test2=NULL...

I have a table, e.g. mytable [appdate] [info] 1/12/2004 231 1/12/2004 466 1/12/2004 465 1/11/2004 888 1/11/2004 817 1/10/2004 324 etc. etc. I need myquery [appdate] [info] 1/12/2004 231 1/12/2004 466 1/12/2004 465 I need to query all data from the maxium date...

Is there a faster way to do this? dim getlastdate as date getlastdate = nz(DMax(&quot;[appdate]&quot;, &quot;qryDate_qryExpPosUndHistory&quot;, &quot;[appdate]<=#&quot; & gblparadate & &quot;#&quot;), &quot;&quot;) This command takes a really long time to process. THANKS

I'm using Access 2002 and I make many complicated reports and subreports. Is there a way to speed Access up when querying and calculating the reports? I usually run them at night but since I make so many it would help a lot if I can speed it up. I have a Xeon processor and a Gig of RAM but...

I have an object that I define and set in the main function. Then I try to reference the object within a sub function and it acts like I never defined the object. Is there a way to do this? example Function mymain(abc as string) Dim objDatabase As Object Dim objContact As Object Set...

I'm using this function in Excel and I am getting a #name? error. Any ideas? Function TAXCAL(LT As Double, ST As Double, Lrate As Double, Srate As Double) as double Dim LTax As Double Dim Stax As Double If LT >= 0 And ST >= 0 Then LTax = LT * Lrate Stax = ST * Srate TAXCAL =...

I have the controls set to input my formula into an excel spreadsheet, but my formula does not format correct once set. I am using this code where brow=beginning row and erow=ending row.... brow=1 erow=5 ActiveCell.FormulaR1C1 = &quot;=SUM(S&quot; & brow & &quot;:&quot; & &quot;S&quot; & erow &...