Hi,

I am not checking if the record exists. There are definitely 2 records per LinkID at all times. When a field is updated in one of the records, I need...

Hi,

Thanks, I am able tp link the tables using Joins, but am still trying to figure out how to write the code to check the fields on the other record...

Hi,

Thanks for your replies. I can create the trigger and use the update statements, but am having difficulty figuring out the code to use to check fields on an alternate...

Hi,

Thanks so much for your help. Saved me lots of time.

I ended up using [TextValue] is Null, but same concept. This then works directly with the function of Combo boxes.

Thanks...

Hi,

Is

[TextboxValue] or [TextboxValue] = "

something that I can put in a query? and is the syntax correct? It seems strange that you have put only one inverted comma...

Hi,

Thank you for all the replies.

I would like to use Access Project but cannot at present, as I do not have the time to switch all the programming over.

I think...

Hi,

I don't know if I explained myself correctly then.

I want to write the stored procedure in SQL Server 2005 Express, and I want to call it from Access.

I would...

Thanks

Thanks Bindu,

I have been able to get this output, but I would like to be able to edit the dates when in that view/output.

Do you have any suggestions on how...

Thanks, I can use Count and Group By on one column with one set of criteria,

but I would like to have more than one column showing different values for that...

Hi,

My compatability level is 90 which is SQL Server 2005, so this is not the issue.

Any ideas on how to get the Pivot to be editable?

Thanks

Hi,

Thanks for all your replies. I have used the above code, in SQL Server Express 2005 and received an error message stating that PIVOT was not supported.

It did actually...

Hi,

Thanks for your reply. The DateNames will all be different (ie. not just incremented by 1 in the name). I have used this notation in the example to explain the...

Ok Thanks.

Hi,

Thanks for your replies. In relation to creating the structure (either with script or copying from the other table) and then inserting the data, I have had difficulty inserting multiple...