Search results for query: *

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

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

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]...

Top man - that works a treat!

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

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

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

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

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.

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?

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

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

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

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

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

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

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

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

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)...

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