Search results

I am using some comboboxes on my main form (frmMain) to filter the records of my unbound subform frm(viewlist). I would like to query all of the records that are filtered at the moment and use them in a a chart. However I can't figure out the SQL. Here is what I have: SELECT...

I'm trying to display all 52 weeks of the year in the following format "Qtr1 Week1". Here is what I'm using now: PIVOT "Q" & Format([Week],"q") &" " & "Week" &format([Week], "ww") ; But what I need is to have the weeks start at Week1 every quarter. Right now it returns: Q1 Week12 - Q1 Week13...