Name: [1922] Dai
Member: 108 months
Authored: 131 videos
Description: Hi I'm Dai Just an ordinary guy with an interest in computers who likes making how to videos for others to get the best out of there computers. I ounce did a course on web-design to further my interest in the subject. Got a HNC out of to boot but, lately my interest has turned to doing howto vide ...

Creating a Query [ID:343] (11/15)

in series: OpenOffice Base

video tutorial by Dai, added 08/07

(Showmedo is undergoing major changes. To report any problems viewing the videos please email us and include browser and OS specifics. Cheers - Kyran.)

Creating a query using OpenOffice Base

Got any questions?

Get answers in the ShowMeDo Learners Google Group.

Video statistics:

  • Video's rank shown in the most popular listing
  • Video plays: 386 (since July 30th)
  • Plays in last week: 3
  • Published: 109 months ago

Thank-yous, questions and comments

If this video tutorial was helpful please take some time to say thank-you to the authors for their hard work. Feel free to ask questions. Let the author know why their video tutorial was useful - what are you learning about? Did the video tutorial save you time? Would you like to see more?

You may also want to see our ShowMeDo Google Group to speak to our active users and authors.

Your email address will not be published.

Show some quick comments >>

All comments excluding tick-boxed quick-comments

29. polo ralph lauren shirts clearance Sat, 11 Sep 2010 02:46

thanks man!

28. ofehoveh Tue, 10 Aug 2010 12:42

Hello Dai

Thanks a lot for your nice tutorials.

Could you help me i am searching How to make queries from a form , or using a field in OO Writer form.

Have an idea or or site having a tutorial about that ?

Thanks for your response


27. Bogner Atmungsaktiv Bequem Anti-Falte Tragbar Wed, 09 Jun 2010 15:20

Thanks for your video about creating queries. The pace was very good. I would like to know how to make a criterion for a field that is not a null field.

26. christian louboutin sale outlet Mon, 24 May 2010 03:58

Thanks for the run-through regarding queries in OOo Base, my knowledge had gotten a bit rusty!

25. new balance,new balance shoes,joe's new balance,new balance outlet Sat, 22 May 2010 23:37


24. christian louboutin canada outlet Fri, 21 May 2010 19:38

These are fabulous! Sooo helpful. Thanks!!

23. Robertsew Sat, 15 May 2010 09:14

Thanks so much for your work. You're helping me get on my feet with databases.

I'm viewing your OOo database tutorials. Very helpful. Thank you.

21. r¨¦plique collier love cartier Wed, 07 Apr 2010 15:20

I like this. You have a good method and manner. I want to know how to create a form that say works like a cash register might. I need a button that will bring up an item, create a running bill, subtract from inventory, and do the laundry... Ha ha. Seriously, how do I get this to do complex operations like that?

20. ugg women shoes Sun, 07 Mar 2010 11:25


what about how to do a parametric query

or how to take the criteria from a control in a form?

19. anonymous Thu, 26 Nov 2009 07:04

Thanks Dai

I am a retired IT teacher living in France got myself in a bit of a fix by offering to teach IT here in France in french argh so your video was helpful as I was a programmer rather than DB specialist

Thanks again Linda

18. anonymous Sun, 22 Nov 2009 17:18

Great work! Short and sweet and to the point. Look forward to viewing more.


17. anonymous Tue, 27 Oct 2009 01:51

Thanks so much for your work on these tutorials!

16. anonymous Sun, 25 Oct 2009 19:27

Thank you!

15. anonymous Sat, 26 Sep 2009 20:16


thanks for taking the time to make the video, very helpful. I am now trying to find a way to add time to date fields and store that in a table.

so a table with a date in it on one filed, a field with a time to add (say a year) and then a filed with the two values added. not as easy as it looks.

but thanks again the series has been most helpful


13. anonymous Mon, 17 Aug 2009 16:45

Very helpful, thank you for your good work!

12. anonymous Sat, 08 Aug 2009 04:08

Thanks for the video. I learned a couple of things. I will be looking for more of your videos to better understand using "or" in queries

11. anonymous Wed, 01 Jul 2009 07:06

hi dai,

great tutorials loved the one with the calendar drop-down menu, it has made it much easier to input data.

Now, my database is a set of addresses, and I have set some querries to filter by their postcodes, a 10 miles, 20, 30, 40, and 50. but I need to set a query to show all others beyond 50 miles, any chance you know how to set a querry which uses the previous querries rather than having to retype the postcodes for outsiders and international postcodes.

Could you help me, please? regards Carlos

10. anonymous Wed, 01 Jul 2009 06:50

great tutorial, but I built this database with addresses and set up querries to show addresses by distance range, 10 miles, 20 miles, and so on by comparing their postcodes.

But, don't know of a way to set up a querry showing addresses outside 50 miles, which some times may include international postcodes. Do I set up a filter, or something, I dont know what to do. could you help?

regards, C

You've had covered also the SQL query. It shows that this is very versatile open office database program. Added know how for me. Thank you so much.

8. anonymous Mon, 27 Apr 2009 17:53

good tutorial. thank-you

7. anonymous Mon, 27 Apr 2009 17:53

good tutorial. thank-you

6. anonymous Fri, 17 Apr 2009 18:02

Thanks for the tutorials Dai, sometimes its easier having someone visually walk go through and explain the various features. Please keep them coming.

5. anonymous Sun, 22 Mar 2009 22:19

Very good show. I wonder if you have any other query related tutorials. I am hoping to know more about wildcard queries into data.

4. anonymous Thu, 19 Mar 2009 12:44

Hi, Dai!

Thanks for a great resource! You helped me with my homework. Keep it up & thanks again!


3. anonymous Thu, 19 Mar 2009 12:43

Hi, Dai!

Thanks for a great resource! You helped me with my homework. Keep it up & thanks again!


I think I would need to see your db just to see what it is you want to do.


I'm trying to make a Query for the following scenario:

I have a Table with several columns and many rows. I have a Form in which the user is able to select from about 5 lists ("columns" in the Table). I want to make a Query that will be able to pick combinations from what the user has entered, and output a report. I can't get it to work. I'm not sure I'm even doing this correctly. Is someone willing to help? Thanks!!!

Showmedo is a peer-produced video-tutorials and screencasts site for free and open-source software (FOSS)- with the exception of some club videos, the large majority are free to watch and download.

how to help » about » faq »

Educating the Open-source Community With Showmedo

Although as important as the software it supports, education and documentation are relatively neglected in the Open-source world. Coders love to code, and explaining how best to use or improve the software tends to be deferred or even sidelined.

At Showmedo we believe the community can play a vital role here and also say thanks for the tools and software that make our lives easier. If you have a piece of software you love or a programming langugage you are enthusiastic about, why not make a screencast showing others how to use it? All the stuff you wish you'd been told, the tips, tricks, insights that would have saved you time and frustration.

Screencasting is easier than you think, and we're happy to help you. You can emailus for advice or just use some of the how-to screencasts on the site. This screencasting learning-pathis a good place to start.

Kudos and Thanks for Dai

Create a Form


¥¢¥·¥Ã¥¯¥¹ ÉÏÑ¥
70 months ago


Showmedo's development is fairly rapid and bugs will inevitably creep in. If you have any problems please drop us a line using the contact address below. Likewise, any suggestions for improvements to the site are gratefully received.