Office 2010 Class #45: Creating Queries In Access (16 Examples)

[h231086]

Thank you thank you thank you....

[rosicastillo19]

How do you get the Access data imported into a Word document without the table format?

[sluicetwo]

i wish my professor were this clear...

[sluicetwo]

thank you so much!

[JediMindMFDoom]

Thank you brother!!!!

[ExcelIsFun]

@JediMindMFDoom , you are welcome!

[JeSsThaBBW]

im making a query from a customer table that contains; Customer Number, Customer Name, and Amount Paid for all Customers located in VA (virginia) with a paid amount greater than $1,000.00. BUT VA is no to be shown in the data sheet view.. In the figure of how mine should come out, it has 2 entries but when i go to the data sheet view mine has 5. What am i doing wrong!??! oh yeah this is for Microsoft Access 2010 Chapter 2 project.. CAN ANYONE HELP ME?

[ExcelIsFun]

@JeSsThaBBW , I am not sure. But if the Query answer is not right, either the query is incorrect or the data is incorrect. Meaning, that the logic of the analysis is not wrong, it is either the query creator or the data that is wrong.

[Kinderocks]

ok ok.

you're THE God.

Thanks for all your vids. Highly appreciate them! =)

[ExcelIsFun]

@Kinderocks , you are welcome!!!

[Gbengz7]

@ExcelIsFun do you know how to do days elasped years elasped and so on

[ExcelIsFun]

@Gbengz7 , I am not that good with Access, but maybe formulas like this:

Days: [DateOut]-[DateIn]

Years: Year([DateOut])-Year([DateIn])

[Kinderocks]

You're a God.

Seriously.

[devin3627]

does it matter if you put >= or => in ant order>

[ExcelIsFun]

@devin3627 , it does matter: you must use >=

[Xiteg]

you just saved me on my project tonight. Thanks a lot!!

[ExcelIsFun]

@Xiteg , you are welcome!

[tf2tactics]

thanks for all your videos! they are so in depth but at the same time you present it so clearly and you make it look simple.

[ExcelIsFun]

You are welcome!!!

[Phoerocks]

Wow this tutorial is amazing, srsly THANK YOU SO MUCH!!

[ExcelIsFun]

You are welcome!

[dmr450]

Fantastic!

[ExcelIsFun]

I am glad that you liked it!