Recent content by dvent

Ah! I had more than 1 group. Change to just one group and that's fixed it.

Hi All, I have a "Make Table" query. I want to ensure that the table that is produced does not have duplicates in the first field i.e. Indexed: Yes (No Duplicates). Can this be done? Thanks dvent

been playing around with this again and still no luck i'm afraid. can anyone shed any light?

Renamed but have the same issue.

Thanks for the help DCrake but still not coming out right. I think I've followed what you said but having the same issue:

Might need some assistance here. I have my query containing 2 fields: "MONTH" & "PLANNED GOLIVES" I've created a third query with: "MONTH" & "EXPR1" EXPR1 = DSum([Planned GoLives],"GP_Planned_GLs") This is giving me: 01/04/2010 - 182 01/05/2010 - 338 01/06/2010 - 247 From what I...

I have my totals: 01/04/2010 : 14 01/05/2010 : 26 01/06/2010 : 19 What I want it to show is: 01/04/2010 : 14 01/05/2010 : 14+26 (40) 01/05/2010 : 14+26+19 (59)

Hi All, I have a table containing Go Live dates. I want to produce a cumulative total by months i.e. the GL's in April, the GL's in April + May, the GL's in April + May + June etc. I know I could produce 12 queries i.e. one for each month but I'm sure there must be an easier way to do this...

Thanks DCrake. Done it!

Hi All, I have 2 queries that work out similar pieces of info. The results from the two are shown below: QUERY1 QUERY 2 I want to combine Query 1 and Query 2 to list dates in column A, Forecast GLs in Column B and Expr2 in Column C. I want to then use the table produced to create a...

I could do this but thought someone may have a more elegant way? I was thinking along the lines of using DoCmd.Print -> Clipboard/Image (?) :confused: (?)

Hi All, I have a form containing a few fields. I want to be able to click a button to copy the form to the clipboard, allowing me to paste it into an email as an image. Can anyone point me in the right direction? Thanks dvent

Hi All, I have a form containing a number of graphs (each with their own query) as well as a report that displays some information in a table. I want to show the graphs and the table all as one view. Form: Report: Result I want: If anyone can help it would be much appreciated...

Function used: Function fmax(num1 As Double, num2 As Double, num3 As Double, num4 As Double, num5 As Double, num6 As Double, num7 As Double, num8 As Double) As Double If num1 > num2 Then fmax = num1 Else fmax = num2 End If If fmax < num3 Then fmax = num3 End If If fmax < num4 Then fmax = num4...

Simon B - that's great! Can you show me how I would do the same if I had 8 different Numbers i.e. Number1 to Number8? I've tested it for 3 and it works a treat!