473,385 Members | 1,944 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

select particular records from a table and report them in a different format

I have an Access database with about 40 fields and 500 records. The Project Name and Milestone1 are two of those fields. The Milestone1 field is a date field that has values in the Mon-yyyy (Jan-2013) format. The sample(partly) is as below.
Project Type Project Name Milestone1 Milestone2 Status
AAAA Jan-2013
Tttt Jun-2013
BBBB Aug-2013
Xxxx Feb-2011
Gggg Apr-2013
Yyyy Dec-2012
Jjjj Oct-2013

I want to be able to pull records for current year (Milestone1 = Jan-2013 to Dec-2013) and put it in a format as below:
Project NameJan-2013 Feb-2013 Mar-2013 Apr-2013 May-2013 Jun-2013 Jul-2013 Aug-2013 Sep-2013 Oct-2013 Nov-2013 Dec-2013
AAAA Milestone1
BBBB Milestone1
Gggg Milestone1
Jjjjj Milestone1
Tttt Milestone1

I’m fairly new to Access. Can you please help me with the code that could accomplish this? Thank you for your time.
Apr 24 '13 #1
1 1097
Rabbit
12,516 Expert Mod 8TB
Create a union query to normalize your data. Then use that query in a crosstab to denormalize it on your date.
Apr 24 '13 #2

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

Similar topics

2
by: Siva | last post by:
Hi, i want to know, how to get the structure of the table in query format(create table ...). any one can help me. bye & thanxs Siva Prakash. M
5
by: Terri | last post by:
I have a form with a multi-select combo. I dynamically build a SELECT statement, open a report, and set the recordsource to my dynamic SELECT statement. I count the records returned in the report...
6
by: Sam Johnson | last post by:
HI I tried to send the following SQL string to an open databse, to export a table into excel format: g.Connection = conn 'valid OleDBConnection and Command objects g.CommandText = "SELECT *...
4
by: Jack | last post by:
Hi, I have the following Access DDL statment from which I generated a access table: CREATE TABLE TEST1 (ID COUNTER, NAME TEXT(50), STORAGESPACEASSIGNED TEXT(50) )
1
by: bpforte | last post by:
Hello, I need help with building query, basically I need to select all records from one table that don't exists in second table with status 1, but they can exists in second table with status 0, to...
2
by: ken | last post by:
I have a form frmSchedule and report rptSchedule I need to print out records 4 to 7 of the rptSchedule when I hit cmdbutton on form I can get it to print report for current form Thank you for...
3
by: Anca Floria | last post by:
Dear all, how can I select from a table only those entries that do not exist in a different table? I have a database of clients and just received an excel sheet with new clients. so i created...
1
by: xitron | last post by:
Hi all, I am using DB2 v8.2 for windows. I need to select a table from table 1 in database 1THEN inserting that select result into table 2 in database 2. In DB2 Command Editor, you have...
1
by: sentimental37 | last post by:
Hello everybody, I am developing a c# application in which i am using access2007 database. I want to select random records from the database through an access query in c#.but i am...
1
by: bullfrog83 | last post by:
I have a form that contains parameters for a report. After the user clicks Preview I have code that set's the Where clause for the report's record source. Once the report opens I close the parameter...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.