Search results

Hi, Can someone please help. I am required to bring back a ranadom 10% of data where the [Total_Cost] field is less than £500. Can this be done in one query? I have to use Access97 becuase this is the lowest Office Version we support. :confused: .

If you mean that 1 of the 30 estimates is the one selected by the client then you need to record that in your estimates table. For example you need a field of type boolean (I suggest) that records 1 or 0. It will be "1" for the record (estimate) that the client selects. _ In the query that...

not sure what you mean

You need to group the report by the different levels and then sum those figures in each group footer.

I would avoid using the same form (pop up parameter window) to invoke two different reports. Copy the form and call it something else and make sure all the code is referencing the right report and the text boxes are named correctly... all the normal things. __ Rather than using the Null checker...

Hello, You need option 2. The one that should say: Include All Records from 'TableA' and only those from 'qryAssignee' where the joined fileds are equal. If you've still got problems then zip and attach a copy and I'll have a look.

Thanks, but Iv'e already tried these options and clients want to manipulate reports once exported to word. I know they could buy Acrobat Writer for this but I really want a solution so they can continue to use word. I have other reports that export with colour perfectly, but there is no code...

You need to change the properties of the Join between qryAssignee AND TableA so that you are selecting everything from TableA regardless of whether there is a record in the qryAssignee RClick on the join (relationship) change the properties so that it looks liek this: TableA -->...

datediff( "d" , date1, date2 ) This returns the date difference in days between date1 and date2. You said the format is short date but if the data type is date&time just be careful for with the accuracy. For example: a task started: 01/01/2005 23:50:00 and completed: 02/01/2005 01:00:00...

Conditional Formatting isn't an option becuase I have to support MS Access97 with this. I currently use code in report groups to format specific results. Specifically preformance reports that are grouped by Green 90-100% Amber 75-89% Red 0-74% This works fine while printing and...

Have you tried giving the fields Aliases? If you RClick to get chart properties (instead of double click to get the chart design) you can give Aliases in the record source line. for example in Chart Properties - Row Source: SELECT DISTINCTROW fld_Name AS Name FROM Qry_Customer GROUP BY...

You can do it with code builder in each group of the report where the fields are. 1. In you report design "right click" on the Group Header (or Detail tab, or Reports Footer Tab) or wherever the fields are that you want to be dynamic. 2. Click "Build Event" then "Code Builder" and Access will...