Recent content by chefdaveross

thanks for the replys, im setting up some append queries now kind of tedious but getting the job done

What is the best way for me to update a table from a different file based off the same table with new fields Have old tables on different databases that I would like to update with new fileds while keeping the old data. It doesnt look like I can import specific fields into a table from import...

Rural Guy MVP. That link fixed my problem. I had a group by in the query of my report. Changed it to First and renamed textbox to FirstofName and works great. Thank you for all responses

I have a report that displays my recipe. I use a memo field from the table that displays to enter the method and steps of the recipe such as 1. preheat oven 2 peel potatoes etc. etc. when i run the report, the memo text box truncates and i only see partial text. I have looked to see if I have...

Thanks for the response, I want to define a relationship in the database design do I do that through table diagram? seems that when i try to do the data is mismatched or im doing something wrong. I need sort of o push to get going here. I will make sure to study the books online on this...

heres a basic newb question: How do I create a basic table join in sql. I would like to perform a basic 1 to many rlationships in which I can choose a category on my item table. From there I would like to create a combobox to select the category. I would appreciate any web resources on how i...

Yes almost the same, but notice how you can only select recipes from the dish table and not items, i would like to be able to have the option to have both. thanks

I am trying to calculate a query that lets me populate totals for dishes on my menu. I have an Item query (mayo, butter, rolls, lettuce, lobster meat, fries), with pricing and I have a recipe query (lobster salad, potato salad) (items grouped and calculated) I would like to create a query so I...

Great thanks for the advice. Love the name, represents my world right now :)

Yes I fixed this. I had my login set to network service and not local Went to admin tools/services That fixed this.

Thank you for your response, I was successful in migrating to sql server express 2008 with ssma. Although it looks like the relationships did not carry over. I wanted them to carry over because I am new to sql server and its not like access where you can use the lookup wizard to join tables...

has anyone upsized access 2007 to sqlserver 2008 express? I keep getting this error: The Upsizing Wizard only works with Microsoft SQL Server (Versions 6.50 SP5 or higher). Please log in to a SQL Server data source. I have read that I should be using SQL Migration Assistant for Access, or...

im new to sql server and am using express 2008. i went into configuration manager and enabled tcp/ip and switched log on service to local service. all of a sudden my service wont start. i tried to go backwards and switch back but it still wont start. how can i get it to start again? thanks, david

Very helpful, thank you

Can I install SQL server on my xppro machine or should I install it on virtual machine such as vmware?