Search results

This seems like a strange problem that really should work, but don't know why it doesn't... I have a report that's based on a query. The query uses group by functions. Short example: select Itemgroup, count(*) as TotalNr, sum(Turnover) as SumTurnover from Campaign_det group by Itemgroup; The...

Hello, I have a contionous form with a bunch of textboxes with sum-formulas in the footer (example: "=Sum([PlanAmount])". This has worked like a charm for a long time. After adding a few more sum-boxes, suddenly all the boxes display "#Error", even the ones that worked before. If I remove all...

Hi, I populate a continous form with a bunch of textboxes. Some are from from query, and some are calculations based on the data in the recordset. How do I get Access to present a sum formula of one of the calculated fields? =sum([Box1]) works if [Box1] is in recordset, but not if it's a...

Hi, I have a Access 2003 DB, which is split in a backend and a frontend. Backend has two tables (which are relevant for this question): Articles (Artnr, Price and so on) CampaignWeek (Artnr, Week and so on) Artnr in Articles has a 1:N relation to Artnr in CampaignWeek. In a form, which has...

Hi, Acess2003 Multiuser enviroment Objective: Maintain an Access database, which is highly secured for normal users, while still having admin possibilities. Single sign-on would be nice, but I guess not absolutely necessary. Being quite new on Access, but with some experience with VB, I...