Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BNPMike

    Updating from Calculated Field

    That doesn't really change anything if you think about it. I'm talking about splitting a field up; you're suggesting concatenating several fields. Either way you have the issue of, if you choose to use intermediate calculations, how do you refer to them in your Update statement? The source data...
  2. BNPMike

    Updating from Calculated Field

    Ah! It's coming back to me. What you do is use a view (ie a Query). Save the select query as a Query and then create another query which joins your base table to your query. You can then refer to the calculated fields as if they were real fields and use the values to update your base table
  3. BNPMike

    Updating from Calculated Field

    I did think of that approach. However I am a believer that for functional languages (like SQL) you should take advantage of the visibility of what is going on, and burying values in complex functions is just making de-bugging more difficult. The other reason is that it's so basic, it must be...
  4. BNPMike

    Updating from Calculated Field

    This is a basic question. I want to pull out some substrings and load two new fields. I get my values from: SELECT Interface_List.ID, Interface_List.Identifier, InStr(1,[Identifier],'_') AS Len1, Mid([Identifier],1,([Len1]-1)) AS T1, Len([Identifier]) AS LenId...
  5. BNPMike

    Peer To Peer Network RDBMS?

    You could consider Access as the most accomplished of serverless database products. If you just want a database then SQLite is very widely used. Some versions of MS SQL Server will fit your bill (I think the limits are in terms of threads not users, so you could probably support your workload...
  6. BNPMike

    Is there a cross-compiler for Excel?

    My original question was categorically about compiling a program in Excel format (ie a spreadsheet) to make it run on another platform eg F#. You perhaps haven't read the full thread. I floated F# as it is also a functional language and therefore might find it more natural to deal with Excel's...
  7. BNPMike

    Is there a cross-compiler for Excel?

    Paul - I didn't mean Excel the program. I meant a given spreadsheet. To take the most simplistic case, if my spreadsheet took 10 numbers and contained the function A11 = SUM(A1:A10) then I would want a program that took 10 numbers as parameters, and returned the sum. Actually you make a fair...
  8. BNPMike

    Is there a cross-compiler for Excel?

    Well, I don't want to 'use' multiple languages. That's really the whole point of the exercise. If I cross compile Excel, that's behind-the-scenes just like programming in Coffeescript uses JavaScript behind-the-scenes. In the scenario I mentioned, only the core system is down for...
  9. BNPMike

    Is there a cross-compiler for Excel?

    Thanks guys. The question was did you know where I should look for a cross compiler. I think what you are saying is you've never heard of one, which is probably why I couldn't find one, googling. The original idea for this train of thought actually came from the international health insurance...
  10. BNPMike

    Is there a cross-compiler for Excel?

    Zack I was reading this. MS are saying you shouldn't run Excel on a server, and it is likely to infringe your licence. That might be academic, unless you want to use the Cloud - maybe it's more dificult to get hosting for something contravenes licence conditions. Perhaps if I put it another...
  11. BNPMike

    Is there a cross-compiler for Excel?

    OK Let's take an international health insurance example: Sheet1 has fields where you can enter date of birth, country of origin, country of cover, cover level, additional features (travel etc). Sheets 2 to 10 do various look ups on pricing, elligibility etc tables, error checking and message...
  12. BNPMike

    Is there a cross-compiler for Excel?

    Yes - not very clear, Zack. I'm treating Excel as a model. You put some figures in, press enter and it calculates some other figures. Once you're satisfied your model is what you want, you could then change it from Excel into something Microsoft like you to run in a server environment. Their...
  13. BNPMike

    Is there a cross-compiler for Excel?

    Have you seen a cross-compiler that turns Excel into something that can run on a server? Googling, all I can see is things that turn Excel into a package. The spreadsheet seems to still be/need Excel. I can see somethings would be tricky to translate (eg Pivot tables) but I guess the main...
  14. BNPMike

    Managing Tasks

    If you record and track everything, you are a micro-manager. You need to list all the things you need to understand how long the the project will take, how many people are needed, and what are the dependencies. No project follows that plan, so you then constantly identify what needs attention...
  15. BNPMike

    Hello experts I am preparing a Fl

    Sorry - I don't get it. You say you are preparing these questions but asking other people to answer them. Do you think you know the answers? Why don't you say what the answers are and then we can comment on whether any are debatable. 39 and 40 are fatuous. 38 - what is 'POS' 37 is a psychology...
  16. BNPMike

    Hello experts I am preparing a Fl

    Hi Lora What help do you need? Are you expecting someone to answer 40 questions for you or is there something specific you are asking?
  17. BNPMike

    Composite Keys: Good or Bad?

    If you have a composite key, you have a composite key. There's nothing you can do to change that. Whether you tell Access, or ask it to do anything about it, is a separate issue. You will still be able to use it as a key. I'd be inclined to add an autonumber field as a surrogate because it's...
  18. BNPMike

    WYSIWYG in WebMatrix?

    I'm just reading through the WebMatrix notes. What I've not seen is anything that refers to creating your web page except by writing HTML. Does it not have that capability? If not, what are you expected to use?
  19. BNPMike

    project management software

    Email is great for everyday communication. Windows Server is great for file postings. Excel is great for bug tracking although there is merit in the likes of Test Director/HP Quality Centre. Basecamp etc are solutions looking for a problem.
  20. BNPMike

    Project manager costs in budget

    Typically you put in a task that covers the time you are on the project. It's optional though, and rather depends on whether the plan is serving other purposes eg tracking costs and resource utilisation.

Part and Inventory Search

Back
Top