Introduce Myself

[J_oggy07]

I am quite new to Access, but have used sql before, so no the basics of a database.

I have a pricing toll I use in excel, works well but would be better in access.

I have set tables up and one is Blank sizes, OD , ID and length.

On my form I wish to query this by putting my part sizes in OD, ID and length, then search my blank table to bring by best blank and costs etc.

I thought Dlookup might do it, but this could return a blank which is not the ideal blank, i.e much too big on OD.

In excel i used VBA and loops

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[NauticalGent]

Welcome to AWF!

 

[theDBguy]

Hi. Welcome to AWF!

You might consider starting a new thread in one of the Access forums (Forms or Queries) and post a sample data or a demo database to illustrate the problem.

 

[The_Doc_Man]

Hello and welcome to the forum. I answered your other post in a more appropriate section.