Search results for query: *

Thanks for the responses. I already know everything that has been said. But how do I get the data into the second table with the key being the autonumber of the first table?

I have imported a table which is very big (over 200 columns). I want to split this table into two linked (in one-to-one relationship) by an autonumber ID. Is there an efficient way to do this? I would assume I can't write out table 2 until table 1 has been completely written and the autonumber...

I want to hide the 'File Edit Insert' menubar for the duration of my application. How is this done?

That seems like questionable logic to me. I was hoping someone would know.

I need to speed up query qryMaxThru SSR (below), it uses the two other queries listed. This query extracts the latest record from a set of records with date ranges. The latest date range for each key (SSR/Task) needs to be extracted. This needs to run extremely fast as it is executed many times...

Thanks for the response, unfortunately it does not throw any light on my question...

In Access 2000 in SQL is there any difference when comparing dates to the efficiency of? WHERE MYDATE BETWEEN ... AND ... and WHERE MYDATE >= ... AND MYDATE <= ...

None of my SQL books mention QBE. I thought QBE went out with Borland Paradox. I code in raw SQL because I switch between many languages and development environmants and a knowledge of the Access query builder is just redundant effort for me.

Thanks for the input. I never use the query builder. Never have, never will. I would have much less idea how to do it in the query builder than in raw SQL.

I have tried everything I can think of and get syntax errors. I need to do UPDATE tblA LEFT JOIN tblB ON tblA.X = tblB.X LEFT JOIN tblC on tblA.Y = tblC.Y SET ..., SET ..., etc. etc.

It does matter to me because I am handling huge volumes of data. This is a table that accumulates data over the months and gets bigger and bigger. It should really be in SQL Server but they don't have enough servers here. By the way computer time is not cheap. We are charged for each cpu second.

In the below query I need to do the first 2 SET statements even if the inner join finds no match in tblPriority, is this possible? UPDATE tblSSRData As D INNER JOIN tblPriority As P ON D.TASK_PRI_CD_1 = P.Code SET D.CLOSDATE = ED(PRO_FROM,CLS_FROM), D.COMPDATE =...

The so-called Access guru that sits next to me sat work said the second one would run faster. He composes his queries with the Access tool whereas I always code in raw SQL. I can't really tell which is faster. Since Access has no profiler tool, I don't know how to tell.

Which of the following is more efficient, or is there no difference? SELECT tblSSRData.*, tblPriority.Desc AS PriDesc, tblPriority.Target AS PriTarg FROM tblSSRData, qryMaxThru, tblPriority WHERE (((tblSSRData.[SSR_#])=[qryMaxThru].[SSR_#]) AND ((tblSSRData.[TASK_#])=[QryMaxThru].[Task_#]) AND...

The conditional format feature (in Access 2000) is pretty useless as it restricts you to just 3 conditions and a fixed set of comparisons. The properties are read-only and cannot be set in VBA (according to Microsoft HELP). When I tried to use this facility, I could not believe how pathetic it...

I have this very complex report I've written. Its not a normal report. I build a custom table which just consists of detal lines. Hundreds of SQL calls are used to build this table. This table becomes the report control source. My problem is that the first column needs to print as bold or normal...

Now all I need to know is how to do it. I tried putting some code in the Detail section but could not figure out how to refer to the report fields. The auto-prompter would not display the properties for me to change the FontWeight. Or is this the wrong way to do it?

I'm building a table which will be the input to my report. In the first column I put headings for each row of data. I'd like some of these to print in bold and some in normal weight. Is it possible to have conditional formatting on a field in my report?

Thanks for the input. This is a reporting table so I don't believe normalizing is an issue. Essentially, I'm building a table to be used as input to a report. Each of the Mn column values will be the result of a complex SQL query.

I have a table with columns called M1 thru M12 representing data for a month. Can I load these columns in a loop such as: For i = 1 to 12 rs.fields("M" & i).value = .... Next