Search results

Hi, I have a parameter query in ACCESS 2013 that produces rows of email addresses for a specified class of students, that I want to export/ convert to a text file on a single row, separated by “; “, to transfer to the BCC field of an email for a mailshot. To clarify this is (hopefully) an ACCESS...

Hi, I have a single cross tab query that feeds into 3 reports ( 3 semesters in an academic year) and read that I could use a dynamic form to select the term I wanted to see the report for. my parameters are academic year and Semester I have created the dynamic form, pointed the query parameters...

:banghead:Hi I am stuck on the following IIF statement- i am either "...missing a closing parenthesis, Bracket (]) or Vertical bar (|)"; or "...the expression i have entered has a function containing the wrong number of arguments" can someone with fresh eyes please proof read this? expression...

hi, i intially, I wish to have attendance stats for 3 groups of people over 2 days in a report i have the two queries for the raw data, but wish to combine into a report that will ultimately become a "dashboard" report for half a dozen queries., and can only get one or the other to work do i...

Hi All, forgive my ignorance/ inexperience. I need to print a set of letters to a group of say 20 people, generated from a query result. Currently i am using the same access query and then opening Mail merge in Word, which works great, and i can select individuals from the list of recipients. I...

HI, i am trying to create a pivot table query in ACCESS 2010, from 2 columns of data- status field and a year field, without having to export through excel etc. however in excel i can use a field for row headers and then the same field for Count of... in the data area. ACCESS is prompting me for...