Search results

Brian; Agree with you. No grouping is necessary. Didn't notice the aggregation in the OPs original query. I just added the criteria in the QBE, tested it for results (which worked) and then posted the SQL statement. I should have looked at it a little closer. Thanks for pointing that out.

Amended your SQL statement for your query as follows and it populates properly for me. SELECT Sum((CInt(Format([Downtime(Hrs)],"hh"))*60)+CInt(Format([Downtime(hrs)],"n"))) AS TotalMins, tblBreakdowns.BreakdownID, tblBreakdowns.[Date of Breakdown], tblBreakdowns.[Machine Name]...

Here is a very good link on the subject of Access Runtime. http://www.hitechcoach.com/ Scroll down about 1/3 of the way for a detailed explanation of what you need to do.

Try putting your code in the On_Load event for the form.

The only way I can think to do this is to create a query with the concatenation in a new field. Then change the select query to a make table query and create a new table. Now what happens when one of the values (perhaps the address changes)? You have a table with incorrect concatenated data...

Why would you need this calculated field in a table. You can recreate it anytime you need the information in a query. What you are attempting to do is not normal to RDBMS.

Link your excel spreadsheet to Access and if it is in table format, then it will appear as a linked table. If changes are made in Excel, they will be immediately appear in Access as they are linked. You can then have your form bound to the linked table.

Captain and Coke

hovered over the

Patel sang his

the heinous act

the Crown Prince

elephant guns which

Are you sure that Marlin47 is a proper Englishman? :confused:

As they say at the White Sox games. Na na na na. Na na na na. Hey. Hey. Good-bye!

Here is a link to the syntax. http://msdn.microsoft.com/en-us/library/office/aa193080(v=office.10).aspx

And once again one of Col's Posts has been highjacked. :) Best entertainment I've had all day and it wasn't even Col making statements.

surrounded by large

of Victoria Bitters

Bleep-blop Please read this: http://www.excelguru.ca/content.php?184