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 Rhinorhino 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. Bunting

    evaluating next and previous records in group

    Hi I have a report with a group on 'Customer_ID', each customer can have any number of accounts that sit under their customer_id and will be displayed in the details section. What I would like to do is create a string that shows the balaance of each account and display this in the group...
  2. Bunting

    Maximum working day in currentmonth

    Many thanks for the prompt respones: Ian, the Lastwrokingday in month formula that you kindly posted does not appear to work for dates after February, I can't work out why, any thoughts? If dayofweek(Date(year(dateadd("m", 1,Currentdate)), month(dateadd("m", 1,Currentdate)), 01)-1) = 1 then...
  3. Bunting

    Maximum working day in currentmonth

    Good morning, I am trying to establish the dates (dd/mm/yyyy) of the first and last workings days of each month and would like to return the results in two separate formulas; - (@First working date in currentmonth) - (@Last working date in currentmonth) I define a working day as day in [1-5]...
  4. Bunting

    Supreport shared variable displaying one row below

    Top man - that works a treat!
  5. Bunting

    Supreport shared variable displaying one row below

    Hi My main report shows stock levels by 'client'; I have a group based upon 'client' and have inserted a summary in the group footer to show stock levels. My subreport shows sales volumes by client and is inserted into the main report group footer and linked on 'client' The values from the...
  6. Bunting

    Cross tab formula (column headings)

    Good morning Within a cross-tab report I have a formula as the column heading which returns a numeric value; this value is the datediff between two dates. I will be using the data returned by this report to populate a rigid template that has column headings from 1 - 60 inclusive. The...
  7. Bunting

    Split string into seperate fields using space as delimiter

    Thanks to all for the responses. We have been asked to output a file from our database into a rigid template; for each record that we output we MUST populate the 'Surtname' field within the template. However the problem we have is that the surname could be stored in one of two places; either...
  8. Bunting

    Split string into seperate fields using space as delimiter

    Just returned from holiday!! Examples of data include: Mr Stephen Harrison Mr Stephen J Harrison Mr S Harrison Mr S J Harrison The following scenario presents an additional problem whereby two spaces exist, i.e. Mr S Harrison
  9. Bunting

    Split string into seperate fields using space as delimiter

    Hi Ibass / Raja. No the full name is not always three pieces and this is the challenge I am currently facing with the solution posted by Ibass. Many thanks in advance for your help.
  10. Bunting

    Split string into seperate fields using space as delimiter

    I have a string field that consists of a customers full name, for example "Mr Stephen Harrisson" I need to display the above example in three seperate fields ie: "Mr" "Stephen" "Harrisson" Can anyone tell me how to separate the above?
  11. Bunting

    Batch File Password for Linked Table

    I'm trying to write a batch file command to run an Access macro. The Access database itself is not password protected so the command opens it. However the macro involves linked tables from a database which is password protected so I need to include log-on details for it. Can anyone tell me how...
  12. Bunting

    Batch File Password for Linked Table

    I'm trying to write a batch file command to run an Access macro. The Access database itself is not password protected so the command opens it. However the macro involves linked tables from a database which is password protected so I need to include log-on details for it. Can anyone tell me how...
  13. Bunting

    Schedule Access Macro Using Link Table Logon

    I have set up an Access database which includes linked tables for a separate non-access database. I've created a macro which calls two make table queries on these linked tables which I want to schedule in Windows scheduler. So far the only way I have found which even begins to work is to create...
  14. Bunting

    Export Explorer Search Results

    Hi all, does anyone know how to export the results of a search in Windows XP explorer? Preferably in comma delimited/excel format but any usable format would be good. Cheers
  15. Bunting

    Convert String to Number in Query

    Excellent, thanks Borislav - you and George have solved a problem I've been working on for some time.
  16. Bunting

    Convert String to Number in Query

    Thanks George, that looks to be just what I'm looking for. I do have a further question though. I should have mentioned, some of the Account_ID values have fewer than seven digits, is there a way to modify your query to check for 7 digit numbers, then 6, then 5, then discard any others which do...
  17. Bunting

    Convert String to Number in Query

    Hi there, I wish to write a query which will retrieve a number of fields plus one calculated field. The field data.narrative may contain an account_id as its first 7 digits, I want to retrieve these digits and use it to link elsewhere in my database but the account_id must be a number to be...
  18. Bunting

    Select DateTime field based on today

    Excellent, that's paerfect. Thank you for your help.
  19. Bunting

    Select DateTime field based on today

    Thanks for that, I think I can see where to alter my query but I still get an error message. I've changed my code to: WHERE "Activity_Log"."Log_Date" IN CONVERT(SMALLDATETIME, CONVERT(VARCHAR(8), DATEADD(DAY,-7,GETDATE()), 112)) TO CONVERT(SMALLDATETIME, CONVERT(VARCHAR(8)...
  20. Bunting

    Select DateTime field based on today

    I need a query to select records using a DateTime field based on today's date without worrying about the current time. I currently have WHERE "Activity_Log"."Log_Date" BETWEEN DATEADD(DAY,-7,GETDATE()) AND DATEADD(DAY,-1,GETDATE()) My problem is that I want to select full days, so if I run...

Part and Inventory Search

Back
Top