Search results

Thanks! :D Thanks for your reply - that's done the trick G

Hi My database holds details of department activities in a table named 'Activities' (somewhat unsurprisingly) each different type of activity has its own seperate form, to aid data entry. The problem that i have is that 2 activites are related - Deals and Press releases. A Deal will almost...

I've got a report that needs to be exported to MS Excel. I have run into a problem where a memo field which views OK in the report is truncated to 127 characters in length by the time it reaches Excel. Does anyone know how to stop this? PS I'm using a macro that Uses OUTPUTTO Excel and...

Cracked it after looking in the queries forum! :) Just needed to use DATEADD!

Hi I have 4 reports that are based on parameter queries. Each report shows a list of business activities and related info over a date range that is set as the parameter. The 4 reports together form a single report that must be circulated to the company. I would like to save time by making a...

Hi I am working on a new access system at work (my first project of this kind), and would like to make a query that acts a bit like a trigger. I have a main table called activities which holds data about departmental activities. When our company makes a deal, a press release is sent out. I...

Whoah - replies thick and fast now Thanks Rich - I shall look at tackling the problem this way. I've never made a report like that though, so the results could be, erm, interesting!

Thanks for your response. I am sure that there will be a way around this though, or at least I hope so, as otherwise I'm not going to be able to get a usable report out of the system. I might look at crystal reports - not sure if they would have an option to format the data in a more...

Thanks for your quick reply - the problem is that some activities involve 23 or 30 users, resulting in a report that spans too many pages. Any other suggestions? Thanks Graham

Hi I am currently involved in my first access project at work, and have come across a report problem that is beyond my (rather limited) skills. I need to produce a report that shows a list of activities, along with a list of the people involved in those activities. The activities are listed...