RE: crosstab query failed emergency help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

yes sir i know that functions to get monthname() and date . im formating in
the query property as mm/yy and dd it is simply giving me in the required
format .
(2)when im doing in select query it is giving all necessary data under 3
fields as month/year , date , attendence.
(3) to get every date of the month i used sql maketable query
dateserial(year(date(),1,serialnumber) serial is the one table with field
serialnumber containing numbers from 1 to 365 its giving me full year dates
in the format dd/mm/yy and innerjoin with above table
where im failing is to transpose the date and attendence fields aginest
groupby of month/year field
the requirement of report is like this
DATE>> 01|02|03|04|05|06|07|08|09|10|....|31|
MONTH!|
10/08 |P|AB|P|P|P|.......
11/08 |A|AB|P|........
sir im going for exam now bless me, i decided to create an excel object
and copy the month/date , and attendence data to it using copyfromrecordset
method and copy and transpose the column there and then hide or delet the
transposed attendence column however im doing absolutly rubbish bless me good
luck next time
how to do in access?

"Duane Hookom" wrote:

How far have you gotten with this problem? Have you looked up crosstab in
help? Do you know how to return the month name and day of month based on a
date value?

--
Duane Hookom
Microsoft Access MVP


"balu" wrote:

dears,
here is the table and report requirement any one please help as im going to
face the exam on 10/02/08 13.00 hrs please .b'cse its my employment .
here is the table Employeename . text
employeeid . number
fromdate . date/ time format (dd/mm/yy),
todate . date/time format(dd/mm/yy)
duty lookup >( absent or present)
REPORT: Required in the manner is say for eg,in excel format
month in one column(a3) as jan,feb,march,april,..til december
date in top row(b2) that is 31 days like 01,02,03,04,...31
employee present or absent is required for individual day
for the perticular month and date right below the perticular day & aginest
month
i beg all my community friends to do best for me please
thanking you.
.

Relevant Pages

  • RE: convert a number in "12345" to 12345
    ... Thank you Sir. ... This is my data field - Claim_Number - ... The data is in text format and has strings. ... exactly how to do this in a query. ...
    (microsoft.public.access.queries)
  • Re: formatting a calculated number field on a form
    ... > A query in an MDB file CAN call a user-defined function. ... > function name is Age and it returns a double. ... The user will certainly "notice" if a patient was born on Jan ... I just want control over the *display format* of a number ...
    (microsoft.public.access.forms)
  • RE: Query count then average.
    ... What was happening in my database was the query returned the ... "Ken Sheridan" wrote: ... It probably depends where you set the Format property. ... "Robert F." ...
    (microsoft.public.access.queries)
  • RE: Cannot get code to work for API Save Dialog Box
    ... I got it working to format correctly now. ... that table in my other queries and union query. ... The code is actually working by giving me the totals I need. ... The first spreadsheet placed where I told it to be contains the incorrect ...
    (microsoft.public.access.forms)
  • RE: Excel & MS Query caused compile errors
    ... My data is in an Excel file called ... The format of it were distorted after copying and pasting. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
    (microsoft.public.excel.programming)