Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mjross

    Calculating number of weeks between two dates

    I'm using 2000/2003 and it works fine there. Can you copy the SQL into a new query (dont use the query wizard, just click Create Query in Design View, Cancel the box asking you to select tables etc, switch to SQL view and paste in) and try running the new query?
  2. mjross

    Calculating number of weeks between two dates

    You need to enclose your dates in # so Access knows its a date, "" is text thats why its returning no result. Amend your SQL to SELECT DateDiff("ww",Now(),#1/4/1997#) AS Weeks; and it will work. You don't need a dummy table, you can save the query as an SQL query, you could also declare a...
  3. mjross

    Convereting a Field Type

    Hi, yes I've tried CVar and get the same, DBSrrcv.dbo.recv_doc_line_tax.recv_doc_line_nbr is an integer. Thanks for replying.
  4. mjross

    Convereting a Field Type

    Ok, thanks for trying anyway.
  5. mjross

    Convereting a Field Type

    Thanks for the suggestions. Yes, I saw the comma and took it out,it still produced the error. I am not creating a report, I'm creating an information object so I don't have the option of overriding anything.
  6. mjross

    Convereting a Field Type

    Thanks for that, unfortunately it produces the same error.
  7. mjross

    Convereting a Field Type

    This is probably simple but I can't get it to work. What I need to do is convert a field from integer to varchar, so I can join it to a field in another table. I have tried to produce a Computed field using the Conversion function in Query Editor, however I get the following error...
  8. mjross

    How to hide report row

    Great thanks just what I wanted.
  9. mjross

    How to hide report row

    Hi, Is there any chance you could post an example of the code to do this? I'm new to coding Actuate and struggling with this. My situation is I have two columns and if the value of both are 0 I want to hide the row. Thanks

Part and Inventory Search

Back
Top