Can this be done?!!

[djbls]

Help - please

I have a table that, amongst other fields, has a Unique ID for each record and a date created. I'd like a crosstab like query that shows the number of records created by month.

It would look something like:

Jan Feb Mar
Number Created 5 15 30

etc

I don't want any other information - only the total created for each month.

I've tried creating crosstabs but, I don't have enough field to satisfy the wizard.

Any help with this is VERY MUCH appreciated.

Thanx​

 

[gemma-the-husky]

have two more columns in your query, one for myyear: defined as year(datecreated), and one for mymonth: month(datecreated)

the only other column you need is the datecreated, or the id.

change the query to a totals query.

the year and month columns should be GROUPBY, and the other column a COUNT. That should give you what you want. you can sort by year and month columns to get a sensible order, ans/or filter them to get just this year, etc

 

[djbls]

Hi

thanx Gemma for the quick reply! Will give this a go ASAP

D

 

[djbls]

Gemma,

sorry, I muyst be doing something realy stupid! I can't get this to give me the results. It doesn't total for month either in a standard totals query or in a cross tab.

I added the two extra fields to the query as you said (I think!).

I'll keep trying but I can't see where I'm going wrong.

Thanks very much again

D