Recent content by Gigantcus

Will do that once I get home. /Edit Here are the images. The data in appointment table is just copied from customer table. note: the data is made up.

Hello, What I'm trying to do is making Cascade update and delete between two tables. For example in my case I have Field called Full name in table1 and I want the same field in table2 that will update when something is added in table1 and vice versa. I have tried relationship but I got an error...

Thanks Pbaldy. For anyone wondering what expression I used in my query, here it is: Annual Checkup: DateAdd("yyyy",1,[Appointment Date])

It's quite hard to explain based on what information you gave me.. Try to play around with this to see if you get what you are looking for Name of the field: [Field1] + [Field2] the name of the field is how you want to name the new field that will hold in the calculated data. the [Field1] is a...

Hello so I have done my query and all but now I just need to add last field which is "Appointment date". I want to make an expression that will add 1 year for every date so for example I have date 01/01/1999 and the expression would change it to 01/01/2000. Is this possible to make in query or...

Let me guess.. ICT BTEC lvl3.. ? :D To the topic.. simply add all of the data in the query as normally and then at a blank field you have to write an expression. You write the expression to the first row. Sorry I don't really know a lot about it as well... I would send you a link to a video...

Hello! I'm new in Access and don't know a lot bu I learn quick.. I'm stuck with one thing. I'm creating a database about Vets and I need to make a button on my menu form that will open something like message box that will allow me to type in something (in my case Customer ID) which will then...