Search results

Hi, This is probably really easy. I have searched the fourm but with no luck. I have a field in a table with dates in it. I want to set up a query and pull down the date field twice, and want the first to show just the earliest date and the second to show the latest date. Is there a way of...

Hi, I have my report set up. This is linked to a crosstab query. The CT query is linked to another select query. I am showing all records from one table as the column, and results are showing next to each. I also have a field in my query which has values in, but only next to records in my...

Hi, I have my report in Access set up. I now want to display this report in Excel or word showing it exaclty as it would be if opened in Access. I have tried the built in functions but when the document is transfered the layout changes and looks messy. Is there anyway of doing a sort of...

Hi all, Access is new to me. I have a table with number values, and in my report I have a total count which adds all the number values in the table together =sum([CountOfID]). I now want to divide this total against each individual value and multiply it by 100. Example 7 is a value in the...