Recent content by MATAdmin

  1. M

    Time Span with dates

    How can I make a query that will take a field that I already have set to record the last contact date and check it against today's date to give me the span between the two?
  2. M

    Cast Not Valid Exception

    Can't find GridView I can't seem to find the GridView tool in my toolbox. It isn't in the list of tools to add or remove either. I'm using Visual Studio 2003. Does this not come with it?
  3. M

    Cast Not Valid Exception

    I'm not familiar with GridView, can u explain?
  4. M

    Cast Not Valid Exception

    I am writing an application in vb.Net that pulls data from a table in a SQL Server, loads it into an array, and then checks certain fields against another array that I pulled in from an excel file. I am doing this because certain users are unable to simply import the excel file and query the...
  5. M

    Stored Procedure involving dates

    There is the ID #, School Name, City, State, and what they ordered.
  6. M

    Stored Procedure involving dates

    I have a rather large table that I need to run a stored procedure on to get the records in which there is a date span greater than two years. In other words, I want all the records after 12/1/2005 in which there was not an order (not a record) placed previously for over two years. How should I...
  7. M

    Report Taking Too Long

    I work with an online ordering system that uses an Access front end and a SQL Server backend. My predecessor set up our sales report based on a Sub-Procedure. It is my inderstanding that using sub-procedures is faster because it runs within the SQL server, though sometimes not the first time...
Back
Top Bottom