10-11-2013, 12:17 PM #7 manusri Newly Registered User Join Date: Dec 2012 Posts: 29 Thanks: 11 Thanked 0 Times in INSERT QUERY is instantenous and only inserts timestamp when a single query cycle that calculates data on 170K records is completed.

Why is it working on my old Access, why is runSQL command ignoring properly closed date string and keeps omitting closing #?

It comes with a tutorial cd so you can use the practices with a database that's on the cd. Design and test with the SELECT piece. INNER JOIN tblClientAddresses ON tblBasicDemographics.ClientNumber=tblCli... Syntax Error (missing Operator) In Query Expression Join IT'S ACHIEVED!

DS Cluster - Follow our Sitemap 418,417 Members | 1,820 Online Join Now login Ask Question Home Questions Articles Browse Topics Latest Top Members FAQ home > I need help with negotiation The shrink and his patient (Part 2) more hot questions question feed default about us tour help blog chat data legal privacy policy work here advertising You currently have 0 posts. weblink In order for your command button to work properly, both the [DirectorsMeetingDay] and the [Combo0] must have the same Date/Time format.

Follow 1 answer 1 Report Abuse Are you sure you want to delete this answer? I've looked how Access give the SQL statement back and in SQL Server it gives me no errors. Copyright © 2013 TimeKeeping Systems, Inc. I am fixing their mess and i cannot for nuts figure out why the error comes up.

Describe logic error, syntax error and run? You need a good naming convention. __________________ Regards, Paul Eugin To view links or images in signatures your post count must be 10 or greater. You cannot equate Number to a String..