|Microsoft Access Forum||Small Office Networking Class by Richard R: I'll be covering setting up a network in a future Windows class. Setting up your Access database on a network will be coming up soon.|
|Microsoft Access Forum||Between Dates by Richard R: Use the BETWEEN keyword. Covered in Beginner 3.|
|Customer Testimonials||Kid in a Candy Store by John Davy: I started watching the SQL 3 videos as soon as I downloaded them. I love them! I am like a kid in the candy store with your videos. I worked for the state education department for 30 years supervising teachers and you are the best I have ever seen. You are smart. You are masterful with Access. Most importantly - you are a great teacher! You more...|
|Microsoft Access Developer 12||Microsoft Access Developer 12 by Richard R: test|
|Microsoft Access Forum||Small Office Networking Class by Anna: I'm attempting to introduce and integrate Access into a friend's business. Immensely enjoy your lessons and would appreciate if you can find time to instruct how to set up a network environment.
|Microsoft Access Forum||Between Dates by Pete B: I built a database in which every record has a date of birth (European notation: dd-mmm-yyyy)
What query criteria must I use to show all dates of birth for one specific year?|
|Microsoft Access Forum||Microsoft Access Forum by Pete B: Very helpful!!|
|Microsoft Access Forum||Lock Table by Normand G: Yes the CustomerF is open.|
|Microsoft Access Forum||Access 2013 by Nelson W: SELECT DividendsT.ASX, DividendsT.DivDate, DividendsT.DivShares, DividendsT.[DivRate$], DividendsT.Unfranked, DividendsT.[Franked$], DividendsT.FrankingCr, DividendsT.DivRecd
WHERE ((DividendsT.DivDate) Between [Start Date] And [End Date])
ORDER BY DividendsT.ASX, DividendsT.DivDate;
|Microsoft Access Forum||SalesRep Email Address by Normand G: I have a SalesRepID on the CustomerF I need to send a PDF by Email to him... I can I do this? I already have an Email address on the EmployeeT.
|Microsoft Access Forum||Wizard by Susan W: I just did some terms ing and it seems to be working okay now. I'm sorry, I should have let you know.|
|Microsoft Access Forum||Access Short Text Field Size by Gerald Y: In Access Beginner 3, Field Properties 1, where we talk about wasted space:
It should be noted that for data in a text field, Access does not reserve space beyond what is necessary to hold actual values.
See https://support.office.com/en-us/article/set-the-field-size-ba65e5a7-2e6f-4737-8e72-36b93f966a33 at the bottom of more...|
|Microsoft Access Forum||divide two queries to get percentage by jannette j: want to join two queries so i can take the count of one query and divided by another query to get the percentage of work orders that were completed.
the numerator query:
[code]SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder
WHERE (((MaximoReport.WorkType) In more...|
|Microsoft Access Forum||Microsoft Access Forum by david P: In Exper7 we learned about ManytoMany relationships. I am wondering if that relationship will work using the same table. Such as a CompanyXCompany. The reason I ask is how to perform a partnership with a company in CompanyT and a Partner from the same CompanyT. If I select a partner from the sub form, I would like to see the reverse show more...|
|Microsoft Access Forum||joining queries to one by jannette j: i need to get some help with a doing some calculations with a lot of
criteria into percentages.I have many of queries were simply to come up with a number that is a count of records with a specific criteria, to be used later in a calculation. Because those criteria are so lengthy, and change with each variation of the data i use more...|
|Access Work Order Seminar||dbl clk by Matt: 10:40
you don't need to check because your picking a Value when you dbl clk the list box so can't eliminate the IF statement in the dblclk event? Reply from Alex Hedley: If memory serves its because you can double click a list box without actually having a selected/highlighted value so this is in place to make sure a value is passed to the necessary part. |
|Microsoft Access Forum||Drop Down by Keith A: DROP DOWN List made by field lookup wizard works great. But.... If I try to do a query on using that field as a filter - it won't work as the value is a number - not the text from the list. Reply from Alex Hedley: Have you tried using the .Column property to get the value you need? |
|Microsoft Access Forum||Join Queries by jannette j: I have 11 queries that each of the quers have two one for numerator and another for denominator how can i combine all to create a crosstab query for a report.|
|Microsoft Access Forum||Access 2013 by Nelson Wallace: I think I am almost passed my use by date when it comes to learning but I am enjoying the challenge. I have come to a standstill while developing a program to keep track of my dividends on a financial year basis to tax purposes. By the way I am in Aus so we use En date format not US.
The problem is although I have the ticker code as the first field. And more...|
|Microsoft Access Forum||Join Queries by jannette j: i have two queries I want to join so i can get the percentages from each department of completed work orders but not sure how to go about it. I know i want a join and a crosstab query so i can display the results in a report.
The first query calculates the numerator,
SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder, more...