This is great! Thank you for your help.

It even makes creating the SQL statement itself easier.

Thank you again.

Thank you,

Worked first try. I was simple after all. I did move the alias but never thought I needed a second one.

I feel a little foolish.

Thank you again.

A question about these statements.

INSERT INTO sqlTable (SQLCode, SQLDescription) VALUES ('A', 'Apple')

INSERT INTO sqlTable (SQLCode, SQLDescription) VALUES ('B', 'Banana')

INSERT INTO sqlTable (SQLCode, SQLDescription) VALUES ('C', 'Carrot')

If I run this though...

This is going to take me a while to figure out. I really appreciate your help. Like the previous post says this takes Access, or at least my...

Your last option sounds great.

However I (honestly) do not know how to have a stored procedure insert more than one record from an Access table. I may have hundreds...

Thank you,

I've been reviewing it and there are some things I can definately use.

The down side to using some of these for select, delete, etc... is (I think) I have...

This is off topic and I apoligize.

I see that you created an SQL query on the fly and executed it.

Would you know where I can find a good (complete) example...

I'm not sure I follow.

If I am the owner of Table_B and have reference permission to Table_A.

I can use a column in Table_A as an FKey to my Table_B?

Is this...

Thank you,

I will read up on unique constraints.

Looks like it'll work great.

Thanks again,

If I open the View from the Mangement Console/Studio I can add/edit rows, no problem.

If I link to in in Access, I can add/edit rows from tables but not views.

Well guys,

I have to say thank you. It took a bit but I can put the funcation (i.e. GetDate()) into the View directly. Again, thank you.

However, most of...

It is an open query with a variable, I'm new at this so.... it may not be the most conservative choice of coding.

Declare

...

Fantastic!!!!

On to the next step.

Thank you,

How about this instead?

P.S. for some reason it doesn't work?????????

It keeps saying I have an error near the last ")"

Insert Into dbo.tbl_PosPay_xfer_File_Test

(

ACCTNUMBER

, ITEMNUMBER

, AMT

, ITEMTYPECODE

, PAYEE

, REFERENCENUMBER

, Date_xfer

)

Select

ACCTNUMBER

, ITEMNUMBER

, AMT

,...

Sorry, I'm just very new to this and still learning SQL and all of its related commands.

Here is what I have and would like.

I currently have a view with a...