Recent content by bmacleod

Hi All, When I export a report from access 97 to excel, one of my fields (text) that appears on the leftside in the access report, is exporting to the right most column in excel. Is there a setting to prevent this. I do have one grouping level above this. Any thoughts would be greatly...

Hi Again GingerR, I know the bracketing looked odd the way i did it but I received the error message(invalid bracketing) when i tried the way you suggested. Why I attempted it with only one bracket was because, on the first parameter I received the error message (invalid bracketing) so I...

Hi GingerR, Thanks for your help. It works for my text field but do u know what the proper line code should be for a date/time field using the between command. I used Between [Forms!Frm_ReportCentral!Txt_StartDate] And [Forms!Frm_ReportCentral!Txt_CloseDate] but I was prompted for a...

Thanks Larry but I have already done this and it still didn't work.

Can u create a parameter witin a crosstab query that draws its criteria from a custom dialog box. I have used this in select queries with no problem but it does not work in a crosstab. (Access 97) Any help would be appreciated.

I think this should be a quick one. Can you sort on a calculated field on a report and if so how. Your help is appreciated.

If your table is already created with a list of potential registrants, add a couple additional columns (perhaps a checkbox to indicate if this individual is part of a group registrant and a second additional column for the name of the group they belong to. I would create a form for this data...