Search : in
By :

MS Access Query

PM, on Oct 23, 2009 11:01:01 am BST 
 Report this message to moderators

Hello,

I need some help with a query in access.

I have one table that contains a list of cars and other details linked to it e.g make, model, year built etc...

I have another table that contains years, 1997, 1998 etc...

I wont to create a query that shows me how many cars were built in all the years shown in my second table.

My problem is that the dates in the car table are stored in this format 01/01/2009.. So how do i link the 2 to create my query.

I want the query to show as below.

Year Make Model Amount
1997 Honda Civic 14

Configuration: Windows XP Internet Explorer 6.0
Access 2003

Best answers for « MS Access Query » in :
Coding to link Visual basic to MS Access Show Coding to link Visual basic to MS Access Issue Solution Note Issue Hello, Please I need to know the coding, how to link visual basic to MS Access! Solution You can try this: Option Explicit Dim conn As ADODB.Connection, rec...
How to connect VB6 to MS Access 07 Show
How to connect vb6.0 to ms access 2003 Show
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
How to use a driver ODBC 32 BITS under the Window 2003(64 bits)? ShowHow to use a driver ODBC 32 BITS under the Window 2003(64 bits)? You have a Windows 2003 server (64-bits) and you want to use a 32 bits ODBC driver: one that is usually found in the administrative panel for ODBC on Windows or an external...
[Office 2007] Convert MS Office files into PDF Show[Office 2007] Converting MS Office files into PDF Here is how to create PDF files from any Microsoft Office 2007: Microsoft Excel: xls, xlsx, xlsb Microsoft Access: accdb Microsoft Word doc, docx, rtf Microsoft PowerPoint:...
ODBC ShowWhat is ODBC? ODBC stands for Open Database Connectivity. This is a Microsoft-defined format for communicating between Windows database clients and consumer DBMSs. The ODBC managier can be found in Windows 3.1 and 9x. In Windows 95 and 98, it is...
Random access memory (RAM or PC memory) ShowTypes of random access memory There are generally two broad categories of random access memory: DRAM memories (Dynamic Random Access Module), which are inexpensive. They are used essentially for the computer's main memory SRAM memories (Static...
Memory Stick (MS Card) ShowMemory Stick The Memory Stick (written as MS or MS Card) is a type of memory card created jointly by Sony and SanDisk in January 2000. The architecture of Memory Stick cards is based on NAND flash memory circuits (EEPROM). Memory stick...
Ask your question Reply
They need your help