Search results for query: *

Worked like a charm. Thanks a bundle.

Hi, I have a report which is run on a union query based on another query. The second query has the following parameter for a date criteria between [Enter Start Date] and [Enter To Date] I would like to show this on the Report Header. I have created a text box on the Header Band called...

Hi, I am not to clued up on Access but am writing a small App with a whole lot of reports - I have the following issue and would appreciate any help. I have created a report and in the Detail band I have created a formula to determine the age of an amount - I then want the total of this to...

Hi, I need to update a table based on another table in the same database. Simple one would think but I keep on getting a syntax error. I am pretty sure this would work in MicroSoft SQL but it does not seem to work here - what am a doing wrong? I want to update the tkfirst column of the...

Hi, Just to let you know I found another way of doing it with the array (prompted by Lisa's comments) and it worked as well - thanks Lisa. I will use this as it is better because the users are sort of set in their ways (as you probably all know) and this way I will not have to change the...

Synapsevampire, You Guru you - what a marvellous idea - a bit embarrassed that I did not think of it myself. I will get right onto that. I know the periods are all wrong - don't know what they where thinking but am hoping to get them changed around in the next conversion. A bit disappointed...

Hi, Thanks for your response however I think we are talking at cross-purposes (I feel a bit bad about that as it looks like you have gone to a lot of effort to write the script). I am not worried about the info in my string - I know that it is correct and will work like it is. I don't think...

Hi, I need to write a formula for the record selection based on User Parameters. I have created a formula which builds a String which I want to add to an 'in' clause in the Record Selection. The formula works perfectly if simply used as a field on the report - however as soon as I try to...