Search results

Hello all I have created a form and on that form are 2 command buttons. I have created the VB coding for each of the command buttons, depending on 4 option groups within the form. One button exports the selected option groups to excel and the other into a pivot chart. This works fine on my...

Hello all I'm trying to create a pivot chart based on a query with an ID + 6 entries for data to be displayed. I have created the form for the Pivot chart/table to created from. Now, the form displays the ID and the respective 6 reporting aspects from the original query without a problem...

Hello all Again I'm a bit lost. In my database I import a table and from this table I have 100's of queries. I'm stuck as the table i import has 2 bits of info. ie drug and date. I have managed to seperate out the 2 bits of information into 2 columns using a select query. However, this is...

Hello I am somewhat struggling with a couple of queries. The premise of the 1st query is to find records within a year of todays date and the 2nd query to find those records older than a year from todays date eg. In my query I have a column for blood pressure and another one for the date...

Hello All Please forgive me, but I'm a bit of novice when it comes to MS Access. I have created a database and I would like to export multiple queries (these are counts of other queries, so I would like a number) to exact cells in a spreadsheet, so that I can auto-populate a large workbook...