Depending on the version of Access you are running and whether you performed a 'Complete' installation, you could try running the upsizing wizard (Tools/Database Utilities/Upsizing Wizard) - that should get...

There are third-party tools that will do this for you.  Here's a link to just one of them:

http://www.apexsql.com/sql_tools_diff.asp

And no, I do not work for this company!

Phil

No enough info.  Please post the code for your trigger.  There are some clever people on this site and the cursor may not be necessary after all.

To disable a trigger,...

OK - getting there.  I think you want something like this:

SELECT t1.dest_bol_no,   

       t1.rev_no,   

       t1.comm_code,

       t1.quantity,  

       t1.bol_no,

       t1.trailer_id,        

       t1.pup_trailer_id, t2.order_no

FROM BL_TRUCK_BOL_DEST_COMM t1 join BL_TRUCK_BOL_DEST_COMM_ORDER t2 on t1.dest_bol_no = t2.dest_bol_no and

t1.rev_no =...

Yes, this doesn't really sound to me like a UNION query after all.

Can you provide some sample data - just the relevant fields - and show also your desired output? ...

OK - but there must be some circumstances under which you want the rows from TABLE_b, otherwise why bother with the UNION in the first place?

I can't see any catastrophes on the horizon, but you should of course write the appropriate script and run it on a backup copy of the db just to make...

The first UNION that you did filtered out the second row because it was identical to the first.  Your second UNION has rows which are not identical - so they...

Me neither - can't you just give them a longer description?  This is building complexity that seems over the top.  Are your users particularly (hmmm, what's a nice way of...

I don't think it's as simple as just clicking a 'process all files in folder' check box - unfortunately.

Here's an article that might be of use to you though -...

OK - I think I was on the right track except for the JOIN:

CREATE PROCEDURE sproc_getTestRequest

AS SELECT   tr.[TestRequestNo],

  tr.[TestFolderNo],

  tr.[TestRequestObjective],

  tr.[TestRequestDescription],

  tr.[RequestType],

  tr.[TestRequestSentDate],

  tr.[TestRequestReceivedDate],

  tr.[ExpectedPartsReceivedDate],

  tr.[RequestedStartDate],

  tr.[RequestedCompletionDate], p.*

FROM TestRequest tr...

IsNumeric is available in SQL Server:

select IsNumeric('Hello'), IsNumeric(42)

It sounds to me like you need something like this:

SELECT   tr.[TestRequestNo],

  tr.[TestFolderNo],

  tr.[TestRequestObjective],

  tr.[TestRequestDescription],

  tr.[RequestType],

  tr.[TestRequestSentDate],

  tr.[TestRequestReceivedDate],

  tr.[ExpectedPartsReceivedDate],

  tr.[RequestedStartDate],

  tr.[RequestedCompletionDate], p.*

FROM TestRequest tr left join Project P on tr.TestRequestNo =...

No problem - though this is a SQL Server place really.

I have a friend who is a Notes developer - I'll ask him & see whether he's got any ideas.

Phil

Hmmmm - if this is about SQL Server administration, I'm a chicken tikka massala.

But I've done some Notes in the past.  When you open the Notes connection, are you connecting...