Search results

I've build a rather complicated database about a Car Shop. Now its time to enter some data in it, and I want to build forms to do this first. Here are data of the first table I want to enter data: tblCars #intCarID intManufacturerID txtModelName dteAssemblyDate intModelPrice...

Thnx I'll do that, I just wanted to explore all possibilities for future refference. Thank you all for answering. :)

Ok, thanx for answering. I'll present it in the SELECT query.

Can... In which type of query do I use the date add function Update or Append? Can MyNewdateField correspond to an existing field in database (where the value will be stored). Which field should I put in YourDateField (because I have several in my table) the one I wish to store the date or the...

Yes Thank you guys for your answers you've been very helpfull. The reason I'm asking could it be done by queries is that in my fianl exam from Databases we are only covering the ground up until the queries (its not much but its fine by me :)), I understood it would be best done by Forms, but...

what What should be the value of "yyyy" (which year)?

Thnx Thanx for your answer but you din't really answered my question. I tried to add it as default value but it didn't work so I want to do this. Can you also explain this DateAdd functin, how do I use it and where to find it?

I'm building car shop database and in one of my tables (Cars) I have dteManufacturingDate field. I want to update dteWarrantyDate field which should be calculated as dteManufacturingDate + 5 years. Now I did it like this: in the query builder my Field has value of: dteWarrantyDate...

Thanx Thanx for the answer Gemma. Now when I now I canot do it in the table directly I wanted to ask one more thing: Can I do it via Append Query, and what would be the right syntax for doing this?

Yes but... a. I need to show the calculated value because the whole database is for my school project. b.Yes, thanx :)

Hi I'm building database for a car shop. One of my table (Cars) has these two fields in it intModelPrice (which stores factory price of a model) and intPriceWithTax (which value should mathematicaly be intModelPrice+[(intModelPrice)*(18/100)]). Now, can I set my default value of...