By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,401 Members | 803 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,401 IT Pros & Developers. It's quick & easy.

Need help with access querie!!

P: 1
I have a database with tables and forms. One of those table is the Inventory table, where I have fields like "product" "stock #" "buy date" "paid date" "paid yes/no", etc. I would like to have a form or a querie where I can ask for example:"Inventory paid from 00/00/0000 to 00/00/0000"; "Inventory owe from 00/00/0000 to 00/00/0000". In the same table I have fields like "Salesman Name", "commission paid"; "commission paid date", and I like to be able to ask questions like:"Commissions paid from 00/00/0000 to 00/00/0000" ; "How much commission I paid to this salesman "*********" from this date to this date".
Any body can help me please. You can answer here or to my e-mail: diatel1@yahoo.com. Thank You in advance.
Osvaldo Carlentini
May 15 '07 #1
Share this Question
Share on Google+
1 Reply


P: 49
Simple way for someone newish to Access is:

Create a form - set -up 2 text boxes one date_from the other date_to

create a query with the field you need and in the criteria section of the query which holds the commission pay date reference using between ([name of form]![date_from]) to ([name of form]![date_to])

then set up a command buttom on the "search form" to open the query or a report based on that query

thats a very simple explaination
If you need examples put a draft of your DB on here and we'll help you along

Gareth
May 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.