Search results for query: *

I was wondering if there was a way to run multiple SQL Statements in Access like you can in SQL. I have a bunch of steps that I would like to combine in one script. Thanks Mike

Never mind. I figured it out. Did not know that you could specify a custom format in the format box. Thanks for all of you help. Have a blessed new year.

How would i go about doing that??

I switch it to short date but that always seems to drop the zero still. Can I specify my own format of that field??

There may be a very simple solution to this that I am just missing. I am linking a text file into access. I have a date field that comes in as 11/1/2004. I am trying to populate a table with this date field but I would like for it to be displayed as 11/01/2004. I have tried playing with this...

Thank you all for the feed back. DBomrrsm, your first posting did the trick. I just had to change one thing and it ran fine. I completly forgot about using IN. Mike

I am running a update query and am getting a Numeric field overflow message. I have checked the size of the 9 fields I am trying to upload to with the location the data is coming from. And they are identical. The weird thing is if i open up the query in design view, delete a field and then add...

I have a table with transactions. My transactions have 3 main fields that I am concerned with: Transaction number, Status, and Acct Number. If a transaction was made and then cancelled it would look like this: Trans# Status Acct Number 0001 Processed 12345 0001 Cancelled...

thanks PH. That did the trick. Did not think about using inner joins. Thought I would get the same results.

I am having a problem with an update query. Everytime I run this query: UPDATE STATESTREETRECON SET STATESTREETRECON.CUSIP = "CASH" WHERE STATESTREETRECON.CUSIP = CASHCODE.CODE I am prompted to Enter Parameter Value for CashCode.Code. I have about 30 different items listed under Code in the...

Hey Gladys, Thanks for the tip. I did find to resolution to this particular problem at the microsoft website. http://support.microsoft.com/kb/284200 thanks again, Michael

Thanks

I am new to exchange. We just migrated over to exchange 2000. Since then, a few of the user's that i am supporting are getting the error Unable to update public free/busy data. The contents of this public folder are currently unavailable. Either the Microsoft Server computer servicing this...

Hello all. I am having a slight problem with the string function. I am trying to use the String funtion in conjunction with the convert function. What I would like to do is left justify a numerical value as a set Char lenght. When I try to use the convert (to Char) function without the str...

I have a trigger that is run everyday that updates a table. I would like to automatically save the contents of that table to a file. Is there anyway to write that into a script? Also when I save a file manually to a csv file I always get commas to seperate columns, is there any way that i can...

ms word is what i am having a problem with

Thanks, hope to return the favor one day

I have the constant task of producing flat files with fixed widths. I would like to know is there a way that I can create fixed widths in SQL no matter the length of the data in the record. For example if I have a name column that is 20 spaces, and enter in a name that is 11 spaces, I would...

There is probably a very simple solution to what I am trying to. I am just trying to pull data from a Header and set it to a variable of type String. I have tried many different ways of doing it but nothing seems to work for me. Could you please advise?

Denny, that did the trick. Your the man. Mike