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...

gmmastros Thanks a bunch for your valuable suggestion That was quite helpful Have a good day!

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...

gmmastros, Thanks for your post I had used 9 AM to 5 PM only as an example in my earlier post. In fact, There is data round the clock for 24 hours There is data for every hour , minute and second Again, for each second there could be more than one record, because this company would be selling...

Thank you Actually we have transactions down to the seconds I am sorry that I did not mention seconds Yes, as you suggested, it would been easy if everything was in a single database It is management decision that we have data in multiple tables Any suggestions in this situation

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...

Thank you for your post It was more of a business decision that the databases be maintained in 12 different databases instead of one database. This is because each database is of 1 GB of size and the total size of all these databases is 12 GB MS Access 2007 can have a maximum database size of...

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...

pwise, I tried Date+time between #1/1/2009# and #1/31/2009 23:59:59#, but I am not able to get the result I am supposed to get records till Feb 1, 2009 5:00:00 AM But I am not getting the result

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...