query

QBE – Query By Example Grid – Calculated Field

This post is actually the response to a question I received on one of my videos: Thanks for the help. question: how can I add a calculated field to speech using your code? I’m new Video: https://www.youtube.com/watch?v=rtlswEIQYS0&lc=UgxUoxYnDL-DF1t4R2V4AaABAg I would suggest that you not add a calculated field in your table. Yes, I know Access allows […]

Continue Reading

VBA Calculate – Multiply

In this video you will find out how to load a table into a recordset object, loop through the records, and vba calculate 2 fields. Also you’ll find out how to make a user defined function and call it from a query. Need to know how to insert into a table? See this video – […]

Continue Reading