Search results

namlaim: sorry about that. thanks for the help, too. i was trying to avoid using a *.bat file if possible because the customer can locate the *.exe and its dependency files where ever they wanted, so the file path would not always be the same. plus, i just wanted to know why my exsisting code...

Bodisathva, nevermind about sending the code. i see whaere i was going in the wrong direction. i found my error and have the code working. thanks for the help!

Bodisathva: i still cant figure out what i am doing wrong. anyway you can sedn me your working example?

any help appreciated. i just dont understand why it isn't working as it should. if you run the file Lmmev6.exe from explorer, you will see it creates 2 new files. but, when run from within access, it just dosent work!

i just don't get it at all. here is what i have so far.

the EXE performs some very complex calculations. it is an exe created in fortran and i don't really want to re-write the code for that exe. the exe dosent use parameters, so i can not figure out what the problem is... will try a bat file, maybe that will work, who knows...

the DOS exe looks for a *.csv file that is located in the same dir as the exe is in. if i launch it from windows explorer, it works fine. just not from the shell command...

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

yea, i suppose a seperate query would be the best way... wanted it all in one query, but i can use two...

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

wow, thats exactly what i was looking for. much thanks!

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, hope this will work. I just made it real quick. Focus on QueryA and QueryB. Like I said I need a new query that has the 16 recordsets from QueryA A1 field with the 15 recordsets in the correct place from the QueryB X1 field. Thanks alot for the help so far...

its huge. let me make a db with just what you would need. give me a few mins

The only field in QueryA is the A1 field, which hold every customer. QueryB has 2 fields, A1, which is the customers who made an order on day 1, and X1, which is the value they spent. If you notice, QueryA has 16 recordsets, where QueryB only has 15 because one customer didnt have a purchase...

yeah, they are the same.

that produces a syntax error in JOIN operation...

SELECT * FROM QueryA LEFT JOIN QueryB ON QueryA.A1 = QueryB.A1 like this?

This is one statement I have tried: SELECT * FROM QueryA LEFT OUTER JOIN QueryB ON QueryA.A1 = QueryB.A1 but I get an error (field is to small to accept the value....)