Search results

$COGS is dollars of cost of goods sold. thats a number I need 4 highest values of $COGS for each item, dosen't matter what branch is that.

Pick top$ lines for each item Hi there, LEts say I have a table branch item $COGS we have lots of same items having different $COGS in different branches and all of them are on one table I sorted that descending by $COGS. Now I want to pick for each item only 4 first lines having...

How I can help you?

Well I have SQL 2005 installed on my PC I told to my IT that I'm a gooroo in it. :) The problem is that I don't know a thing about it. I can't even link to existing table. Or to import it into SQL Server. Everything is so unclear there. I tried some books. There is lots of stuff, but I can't...

Yep I've got about 2.5 mil of records, 60 columns each. I manage inventory of international structure The only thing I wanted is to create a 3 digit Branch code automatically. Thank you all for your answers. That was helpful I added a column and got it done.

I ment 2 GB of course The thing is that that table is been downloaded from AS400 every night. The developed table is gonna be destroyed. So is it possible to add a blank column with a macro or something?

Hi there, I have a big table bringing Access up to almost 2G limit. I need to add a column to that table using a query. I can’t make another table because of the volume. I have 3 columns like Company Division Branch W X P I need to add the column having Company Division...

O, I see.... Thank you, By the way... How to delete any same lines in a table anyway?

Hi everyody, Does anybody knows if there is an add-in to Access to download from AS400? Thanks.

Well it works but takes forever. I have tables like 50000 lines. it looks through all the table for each line, so it's slow. Nad another problem is there are double lines remaining where shiping quantities are same. I mean if the are 2 pairs of branches with the same shipping brnach and same...

Let's say we have a table: Sipping branch Receiving Branch Product # Qty to ship a c PR1 43 a d PR1 25 a k PR1...

Pls don't kick me for beginner's questions, but... I'm using Cognos to see OLAP cubes and build reports. The cubes has been built by another department. I'll have SQL server soon. I know thet SQL server can create and keep those structures. 2 questions: 1. Do I need any specific software to...

Thank you for advices. The thing is that there is nothing to administer. I'm gonna work alone with it and I've got SQL Server for my researches only. Access is just unable to chew the files I bite all the time. I'm dealing with inventory files of the really big international structure. So...

Wow! All that is above of my head! You scared me.....

I have Access 2003 and it's gonna be SQL Server 2005

I'm planning make a move from Access to SQL Server. To be honest I never used it before, but I told to my bosses that I'm a Gooroo in it.:) So can you guys give me an idea if it is really hard to make a move, to upload the existing databases and to get used to it. How long it takes? What books...

UPDATE WX SET WX.SLOC = WX.SLOC & "_" WHERE Asc(WX.SLOC)>=97 And Asc(WX.SLOC)<=122 WITH OWNERACCESS OPTION; This is the right one

Yahooooo!!! It works I just put UPDATE wx AS sloc SET sloc.SLOC = sloc & "_" WHERE (((Asc([sloc]))>=97 And (Asc([sloc]))<=122)) WITH OWNERACCESS OPTION; The table name is WX The fild name is SLOC Thanks guys!

I'd like to but how to make this Update query Case sensitive?

Now, I have a big table with sales data downloaded from DB2. We have branches codes of 1 digit only. Because of too many branches we have branch codes in upercase and lowercase. So Q ans q are different branches. I'd like to substitute all lowercase codes like q with something like q_ to make...