Search results

Ok sorry I should have researched more. I've found the way to create this relationship is with an intermediate table. Seems cumbersome, but looks like the only way.

Ah I see!! That is brilliantly simple! However, it does require a many-to-many relationship doesn't it? How can I represent this? In my case it is a form showing details of an insurance policy. Each insurance policy can have up to 3 advisors, and each advisor will have many policies. Access...

Here's a curveball. I have a subform detailing a person attached to a record. I want to attach another person to this record. Can a button add more space to the main form, and put in another of the same subform?

I've found that my report's calculated fields do not display instantly. I don't know whether this is just bad design by me, but they require clicking on in Report view before they show up, so I'm currently trying to move them back to the query

On a related note, I've just been looking into crosstab queries, which seem like they would be the ideal answer to this, apart from the fact that I can't use one as a base for a report. Does anyone know how to refer to crosstab fields in a report?? It would be great if I could say [row...

I've copied the text boxes into a blank new form if that's what you mean? It's just annoying that when I go into layout view, I can't see any fields, unless I go into Report view and click on them all individually. Would it be an issue that I have all these calculations in either the report...

Has anyone else noticed that calculated text boxes don't draw immediately in 2007 reports? I have fairly simple calculations in my boxes, and they show as soon as I click on where they should be, but don't show automatically. Is there a workaround for this? It's just a little annoying thing...

Hi guys, I was trying to redesign my report to avoid having so many DSum calculations, so I have made a single crosstab query with the various sums I want. However, I obviously didn't research well enough into how this would link to my report. The crosstab query has 5 categories of payments...

If you are just changing that heading you can just change it in design view, from: Total Of ContractID: [ContractID] to Total Number of Lessons: [ContractID] Is that what you were asking?

Hi there, thanks for looking. I'm trying to create a crosstab query which gathers fields from two different queries. With one query it works fine, providing summaries of all payments for each advisor, by payment type: PARAMETERS [Forms]![Advisor Summary Request]![txtToDate] DateTime...

Have you looked into the TOP syntax? SELECT TOP 1 Tracking.Container, Tracking.Location, Tracking.Arrivaldate, Tracking.Loaded, Tracking.Empty FROM Tracking WHERE (((Tracking.Location)=[Forms]![Containerpositioning]![location])) ORDER BY Tracking.Arrivaldate DESC; I have no idea if that code...

Ah bummer I was hoping for a miracle there, I need to make this possible. Do you mean open it in design/layout mode?? I can see that causing problems. Unless you mean a button on a report could open up an embedded sub*form*?? Possible?

Is there a way to put an editable section into a report?? I have a financial summary which does a lot of automatic calculations and sums them, but there may be misc items the user wants to add to the total. Can this be added to the form, and the control source of the sum textbox? Something...

Righto, I moved it back to the table's default value. Thanks

How can I set a default value in a report text box ? There doesn't seem to be an obvious option in the property sheet

Thanks for this But I can't reference a different query in a text box(not the report source)??

Hi guys, I'm looking to track changes to a field in my Insurance database. Each Insurance advisor has a percentage of a total pool of investments. This is easy to show, with a field in my Advisor table. However, how can I look back into the past and see what the advisor's investment was 2...

Further to this, how can I use fields from these subreports in a calculation in the main report/another subreport? I currently have the control source as: =Sum([SelectAdvisorNBForPeriod]![AmountIncGST])*[SelectAdvisorNBForPeriod]![NBLevy%] Which just prompts the user for data, like it can't...

Hey, cheers for replying. Sorry it is definitely a report, and I don't want to report on any specific records in the body, only the sum amounts of each sub-query. I currently have the report grouping on Advisor so I have the Advisor Header to put subreports in (there will only ever be one...

Hi guys, just to confirm, I'd like an opinion on my methods. Each advisor has a number of payments made to him, and there are a number queries on these limiting to date, payment type etc, for that advisor. I'm trying to make a single report which presents summaries of each smaller query (total...