Search results for query: *

I am using VB 6. I am fetching values from an MS Access table called SALES. from Sales.mdb It has daily Sales values of the company. It has Sales value for each hour for every day. Hence for each day there might be several records. The fields in the table are DATE, TIME, SALE_COST I need...

I am using SQL Server 2008. I have a Sales table. The table name is SALES. The fields are ID, DATE, TIME, COST_OF_SALES, WK_ID The Sales table has Sales data of the company for about 3 months It has data on a daily basis ( no holidays ) . Every hour there are transactions and the cost of...

I am using Visual Basic 6 as the front end I am using SQL server 2008 express as the back end I am trying to connect to a table in SQL server in MODEL database which has about 140 million records. Table name is dbo.tickdata_master I am using ADO Whenever I am trying to fetch records from that...

I am using Visual Basic 6 as the front end I am using SQL server 2008 express as the back end I am trying to connect to a table in SQL server in MODEL database which has about 140 million records. Table name is dbo.tickdata_master I am using ADO Whenever I am trying to fetch records from that...

I am using MS Access 2007 I had linked a table called tickdata_master from MS SQL Server 2008 I tried to perform a select query on the linked table after I had fetched data from SQL server I got a SQL server error when I tried to Query in MS Access While I am querying Linked tables, can I use MS...

I am using Visual Basic front end. I would like to connect to SQL Server 2008 express edition using Windows authentication with windows user name and password The server name is JSMITH/SQLEXPRESS Authentication is Windows Authentication Server type = database engine I had created a dsn called...

I am using Visual Basic 6 as front end I am using MS Access 2007 as back end In MS Access 2007, I have 12 different databases for 12 different months ( Jan to Dec '08). Each Database is about 1.5 GB. The total size of all databases is about 18 GB Each database has exactly one table called...

I am using MS Access 2007 I have 12 different databases for 12 different months ( Jan to Dec '08) Each database has exactly one table called "Daily_Trans". All databases are exactly alike Daily_Trans table has the sales transactions of the company on a daily and hourly basis. The fields in the...

I have a table in MS Access 2007 which is about 2 GB size I had deleted that table and all its corresponding tables, forms , queries Currently the database is blank But still the database is displaying that is about 2 GB of size and it is not able to import any external data which is of about...

have some data on an excel sheet which I had linked it to a chart. The data is monthly sales data for 12 months. The two columns are month no and sales amount. They are in column A and Column B. I had linked the data to a chart and added a Trend line to it I got a polynomial equation of 4th...

I am using MS Access 2007 I have a table called "price_tab" which has the price data of the stocks that are traded for the company. It has information of prices round the clock for a day ( all 24 hours ) The fields are id, date, time ,price, volume. Id is an autonumber that is generated for...