Search results

I found the solution to my own question so I am posting it for anytong else who might be intersted: SELECT tmp.COL1, tmp.COL2, tmp.COL3, tmp.COL4 FROM [SELECT TestA.COL1,TestA.COL2, TestA.COL3, TestA.COL4 FROM TestA WHERE COL1 IN (SELECT COL1 FROM TestB) UNION ALL SELECT...

Same results at TEST1.

Nope sorry that was the first thing I did but you will notice that it delivers multiples and if you try to group it you lose data. if you look at the query named TEST1 you will see soemthing that looks like it works but if you glance at records 9,10,11,12 an issue appears. For some reason...

Let me start by apologizing for bothering you because I am sure someone asked this before but I can't find the post and I have been working on this for 2 days and I really need to get my own work done. I have two tables with the same fields: PART, DESC, REQ, CHASSIS, SEQ, REPORT DATE. And one...

Well after much soul searching and bashing of my head against the wall I found something in the forums that pointed out that what I am trying to do is not a true use of a relational database. So of course when I log on to close the post and apologize to everyone who took a look at my post...

I have an access database that has a main table and then multiple smaller tables to hold the data entered off of forms. In the main table I use one field ECNNumber for the Primary key then in the smaller tables I use an Auto number for he primary key and index the field ECNNumber. Each...

I have a database and I need to search in the body of the memo field for information in another tables field. Please help. table 1 field Driveline data : 805983D1755 table 2 field memo data: Turn on Speedometer Switches: NO SPDO SWTCHS REQD C/B D/L = 804248D1795 C/B...

how will the launchapp know where the bat file is located?

I am going to go out on a limb and assume that in the code above I need to change MYAppName to the name of my bat file??

I will try to do as you instruct but it might be a little over my head.

Okay I had a brain hiccup, right after I sent the post I realized what I had done. I apologize and I thank you for the assistance.

Okay I did what you instructed, but I get this message when I run the query: Run-time error '3075': Syntax error (missing operator) in query expression '[HolDate] = #10/28/2006#:::Null'.

I deleted out all the wait()'s and ran it but the bat file had not finished running before it moved on to the make table function which cause the bat file to finish prematurely so part of the data did not import as needed.

My boss believes in simple is best so of course he wants everything done using one button. I have written the code that will run multiple things when the button is clicked but I wonder if I should use wait() or something more robust. What concerns me is the the files the button activates can...

I have a database (big surprise :rolleyes: ) and I need it to calculate and filter information based on a process name, a number of days for that process and a schedule date. For the process NC Batch I need it to calculate out 15 working days from today excluding weekends and holidays and then...