Viewing 12 posts - 1 through 12 (of 12 total)
Sorry.,
i am fairly new in sql ad access.
how do i " Get the value, store it in a variable, include it in your query."?
June 2, 2010 at 1:26 pm
Thank you.
i did look at the thread.
But, i don't want users to enter any parameters.
it should generate automatically based on the open record.
June 2, 2010 at 1:12 pm
sorry
this is the right query i need to be converted..
SELECT exxonTesting.[SP Company Name], exxonTesting.[SP Office No], exxonTesting.[Safety POC], exxonTesting.[API Requirements], exxonTesting.City, exxonTesting.State, exxonTesting.[Name Tested], exxonTesting.Completed, exxonTesting.Expires, exxonTesting.[API Key Number]
FROM...
May 24, 2010 at 9:48 am
you are definitely right.
but every other things works very smooth.
except this search issue....
May 11, 2010 at 2:51 pm
i just added an index that includes Tracking NO & Store NO
that screwed my History notes which i related to the another table that uses the same Tracking NO to...
May 11, 2010 at 2:18 pm
should i include Store NO in the index Key Column
and include Tracking NO in the Included Column
May 11, 2010 at 1:54 pm
No
i have the following indexes
1 Clustered on store NO
1 Non-Clustered for Tracking No
most of the search we do is by Store NO...
but i will do that and let...
May 11, 2010 at 1:53 pm
well,
i added indexes. i ran SQL profiler, and imported trace file into Engine Tuning Advisor. which advised me to create more indexes and statistics.
i have attached a copy or...
May 11, 2010 at 12:26 pm
what would be the other option other than access mdb file.?
May 10, 2010 at 12:26 pm
ok
did that..
but still no difference.
does it take time to take effect. it's been more than 24 hrs.
May 10, 2010 at 12:11 pm
thank you
i have an index on the field. from SQL.
or should i put on the local table on Access as well,.
May 10, 2010 at 12:01 pm
Craig,
i think i will be able to convert from Access to .mdp file useing upsizing Wizard. that's if possible. i know it was through SQL 2000
http://technet.microsoft.com/en-us/library/cc917602.aspx
i hope...
February 12, 2010 at 11:13 am
Viewing 12 posts - 1 through 12 (of 12 total)