Time 8:07
1-Why you did not insert the Full Name Field in Table? Why did you inserted it in Query?
2-Which kind of Programming Language did you use in the Field ,Criteria and Or? are they SQL or VBA?

---

Reply from Richard Rost:

1. Because it's MUCH easier to store complex data in it's component parts and then reassemble them later. It's a whole lot easier to store FirstName and LastName in separate fields and put them together into one FullName field than it is to store them as a FullName in the table and then try to pull them apart later.

2. It's not really a programming language. It's how you create a calculated field in Access. Access then creates the SQL from that. You can see it by clicking on the SQL VIEW button (on the Design View button drop down).