6 Monthly query

  • Thread starter Thread starter Bilbo
  • Start date Start date
B

Bilbo

I have a query that returns a monthly count of an activity as a crosstab, but
I need the query to group by 6 monthly instances. Can anyone help with the
expression I need in the query to generate a count of 6 monthly instances?



Cheers
 
Hi I have a question you may be able to help me with.
How can I create an update query that modifies the Arrival and Departure
Dates Fields in the Reservations Table by +7 years. Please help.
 
you woudl have to post your query here so we can see how it is set up
open the query and click on view in the menu bar then select sql view
and paste what is there into a reply

Regards
Kelvan
 
I have a query that returns a monthly count of an activity as a crosstab, but
I need the query to group by 6 monthly instances. Can anyone help with the
expression I need in the query to generate a count of 6 monthly instances?



Cheers
Click to expand...

Try using a a calculated field in a query:

YearHalf: Format([datefield], "yyyy" & IIF(Month([datefield] <= 6, " First
half", " Second half")
 
Hi I have a question you may be able to help me with.
How can I create an update query that modifies the Arrival and Departure
Dates Fields in the Reservations Table by +7 years.  Please help.
Click to expand...
you should make your own topic

try

update Reservations set [Arrival date] = dateadd("yyyy",7,[Arrival
date]), [Departure date] = dateadd("yyyy",7,[Departure date])

hope this helps
 
Back
Top