Search results

Ok, this is very odd. I am running a small DOS executable from within a db. I am using the shell command. The DOS exe is suppose to create a *.txt file. The file creates the *.txt file if I launch it from Windows Explorer. Howeve, if I use the Shell() command, it does not create the *.txt...

ok, i am using pivot in a query. this returns 24 values, one for each hour in the day. i need to sum the values of the first 12 items returned in the query. i need them in the same query. how can this be done? the column is names from 1 through 24, 1 for each hour..

Ok, I'm going to try to explain this the best way I can. I am running a query on a customer database for each day (Monday has a db, Tuesday has a seperate db and so on). If there was no sale in the hour, the database dosent add data for that hour. I am using pivot, based on the hour from the...

Ok, I am working on an exsisting database at work that has alot of code/forms/reports and so on. Whoever worked on this before me apparently didn't believe indenting code or anything like that. Now I don't want to to go all this code to clean up the structure of the code. I remember back a...

Ok, I have having a problem joing these two queries. Can anyone please help me out here. These are the results of my two queries: These are the values in the A1 field of QueryA COCKBURN 2 GT KW 1 GTN 1 IPP GT1 IPP GT2 KALG F5 KALG F6 KWIN C6 MUJA 1 MUJA 2 MUJA 3 MUJA 4 MUJA C5 MUJA C6 MUJA...