Search results

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!

Hi All, I have a table containing data like follows NAME NUMBER1 NUMBER2 NUMBER3 JOHN 1 0 0 LUKE 1 2 0 IAN 0 0 3 I would like to write a query that will tell me the max number per Name i.e...

Hi All, I have written a routine to import some excel sheets into Access. This is tailored from another script I use so I know it works. For this particular workbook however I need to delete the first row of data before it is imported. Can anyone help me with adding this line in? Thanks in...

Hi Rich. There are a number of queries that calculate totals for things i.e. things that happened <Date(). If an event for example happens tomorrow the database will know about the date and if the user sets their machine up to be next Monday, this event will be classed as having happened. The...

Hi All, Is it possible to set the date value for Date() when opening an Access database? Currently I have a database that uses Date() and my staff change the date of the local machine to the beginning of the following week due to the way some queries are written. Is there a way that they...

Hi All, I'm trying to take a table of masterdata and create a better version. At the moment I have 2 milestones in my data for each milestone - a forecast and an actual date. I am writing the following: IIF(IsNull([Actual_Date]),[Forecast_Date],[Actual_Date]) However I have to do this...