|
Type keyword or phrase to search:
My Articles...
Resources
I have other resource websites and social networking sites for you to browse...
Blog, articles, video tutorials
Access Database
Tutorial Blog
Contact me on Twitter
@benbeitler
|
Help!, I need to calculate something in an access query.?
The question is Produce a report which contains a new report called Delivered Price calculated at run time. This field will calculate Cost Price plus a delivery charge of 10 % on of the Cost Price. I would really appreciate a quick answer, thank you
Microsoft access query?
HI We have a databse with about 40,000 items on. If I wanted to do run a update query effecting all items from 1 20000 what forumla would I need?i presume its something like " < 20000" but cant get it to workThanks
How do i update length of string less than 15 to fix 15 using access query?I need to put "0"s to make it 15.?
How can I create a column to name/label duplicates in a Microsoft access query?
I have a list of numbers, some of which are duplicates. Then they each have a title on them. I would like to name each number for which titles it includes, in a separate column. Then I would like it to remove all but one instance of each number, and show me the newly created group. Here is an example of what I'm trying to accomplish 111 John111 Harry111 Steve222 John222 Steve333 John333 MarkI would like the result to look like this 111 John, Harry, Steve222 John, Steve333 John, MarkThe second column which originally included the individual names could stay in, I don't really care if its removed or not. I just want it to have one instance of each number, and the new group name to show which names it included.Thank you so much for any help
Need help setting multiple criteria in access query?
I have a access query which collects data and opens a report. This report is based on a case number which can be entered on 2 different form and by 2 different buttons.When I push button " A" I would like the criteria to be Forms Switchboard Case Number When I push button " B" I would like the criteria to be Forms Case Info Case Number I can make this change happen when the buttons are pushed in the proper order, however I do not know how to change the criteria on this event either in VBA or by some other method . Does anyone know how to have 2 different criteria for a query?
How can add autonumber field in access query?
How can create autonumber field in MS Access 2010 Query?
Can someone convert mysql query to access query?
Here is my code, i'm having a problem with my GROUP BY and nested IF statements, can someone help me convert my code into a MS access query?? thanks in advance SELECT IF month date '02', 'February', IF month date '03', 'March', IF month date '04', 'April', IF month date '05', 'May', IF month date '06', 'June', 'July' as " Month" , SUM amount as 'Summary of Sales' FROM sales GROUP BY month date also, if I use switch statement in my nested if, I'm having an error of " Syntax error missing operator in query expression" .. can someone help me? thanks
How to Concatenated in access query 2010?
How can you concatenated the cost of this in the query field in access 2010 .. some customer have 3 different prices but same customer and some 2 different prices and same name.. How you concatened Jenny $150Jenny $20Jenny $39Chris $12Chris $10James $9James $63Jaes $56
Using the Like operator in an access query?
I'm not sure if you're going to be able to understand what I'm asking but here goes.I'm using a database to store records of of peoples names and where they live after coming to a class, and I generate a code for each individual person. Generally the code would be W001, but if they come again 6 months later with different information I would add an R on the end of the code W001R, so I have records of the old information and the new information. this is a very basic insight to how it works So I'm trying to run a report all codes that contain an R and those that don't contain an R at the end.The first query I have made is as follows Field Where do they live?Table Table1Total Group byCriteria Field IDTable Table1Total CountCriteria Not Like " R" Field Expr1 Format Date Attended ," mmm" Table Total Group byCriteria " May" This works fine and populates the data for me exactly the way I want it to. But if i create a separate query and change the criteria for ID to Like " R" the query does not work at all.I can't understand how the 'Not Like' works and the Like does not. Can anyone help me resolve this? Thanks
|
Books
The following books are my personal recommendations for all levels of Access database users and developers.
Enjoy!
Access 2007
- Dummies
This is a great book for beginners. It takes you through from the very beginning without too much jargon 'computer' talk and adds a little humour to your learning.
This is one of my favourites and is a starter recommendation for my students.
Access 2010 Bible
Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology.
You’ll want to keep this soup-to-nuts Access reference close at hand!
Access 2007 VBA
This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object–oriented programming and ADO. Two comprehensive case studies presents you with the hands–on experience in building real–world solutions using the concepts covered in the book.
It's the one I use as a reference for VBA students!
|
