Search results

Hi All, Struggling to import a text file into an access table in a readable format. Everytime I import the file with space delimited, All data goes into the first field as the fields have a square between the data. if this was a space it would be perfect. Has anyone come across this issue...

Hi All, In need a quick fix, need to get these reports in ASAP. I have a text box which looks at the fields in The "Detail" part of the report. which looks like this: IIf(Len([SumOfCost] & "")=0,[SumOfSumOfActivity Cost],[SumOfSumOfactivity cost]-[SumOfCost]) But in the group I would...

Hi All, Quick question... If I were to do a right join on four different attributes E.g. a = a b = b etc etc and the criteria would be Attendance is null. I am getting the results back which I want but the columns which I have joins on are blank? Any ideas why? Any help appreciated....

Hi, Is it possible to create a lookup in a query against a table which has not relationship but has a match? E.g. iif(spec(in query)=Spec (match table) then bring back cost in (match table) Hope this makes sense? Thanks

Hi, Wondering if anyone has a solution for my problem. I have 2 data sources, one which is an ODBC and one which is an import table. I have a 2 queries each querying the 2 data sources seperatly. My problem is... One of the fields which I need to do a join to a reference table has a...

Hi, I am going to be creating a iif statement update qery, to update a column on dates, E.g. would be.... IIf([FinMonth] between 01/01/2008 and 31/01/2008,1)iif([FinMonth] between 01/02/2008 and 30/02/2008,2)iif(etc etc 2 questions?? 1) Is 12 nested iif's statements are allowed within one...

Hi All, Tried doing this within query, my current expression is... Cost Difference: IIf(Len([SumOfBudget Cost£] & "")=0,[SumOfActual Cost],([SumOfActual Cost]-[SumOfBudget Cost£])) When i replace the zero with a "-" or "blank" then it messes up the formatting of the percentage. Is there a...

Hi, When I am doing this, it is coming up with silly figures... I have got a query which consists of 4 costs which have been summed in a previous query. The result of this query is a rows of datas per criteria E.g. Day 4, Day 4, Day5. When I sum this, I would expect a sum of 13, but i am...

Hi , recently posted a thread about a union query. I have got over that hurdle now but face a new problem which is: When I have created a right join to bring back data from a table, if there is no data it will leave the fields blank. Is there any way I could bring back the row data of the...

Hi , I have two tables: I currently have an outer join getting all the data from Act table where fields match in both tables. How do i get it so if the table 2 does have data which I want to show and table 1 does not but still matches on my joins. How do i get it show in the query...

Hi All, Is there a way on access reports which you can create a high level summary of all the totals of of a group E.g. If i have a group of 5 , i would like to have the the 5 different group headings with the summary data for these? Any ideas? Any help much appreciated.

Hi All, I am wondering what to do to put a default value in feilds which are blank. Would like a default value of 0. There is no default value in the properties of the bound text box in report view???

Hi All, Head is battered with this join query. I have 2 tables which I want to join, one being individual data and one being budget data. I want to Sum the budget Cost And Budget admissions dependant on the joins. SELECT FyldeCoastActivity.Speciality AS [Specialty Code]...

Hi Is there a way you could look up multiple number in a query were the column will be a series of numbers/calculations? E.g. I would want to look for 13001,13002,13003, in a column where there would be calculation such 13001 * 246 13001 * 269 13002 849 etc etc Any help would be much...

Hi I have come to a dead end with my query. Any help would be really appreciated. I have a query which i have written: SELECT TblBurnleyWwTw.MetricID FROM TblBurnleyWwTw WHERE (((TblBurnleyWwTw.[Data Source])="OMS")) OR (((TblBurnleyWwTw.TAGFunction)="CHP")) GROUP BY...

Is it possible to create a combo box to list all record ID, when selected that record appears on the form?Ifso how would i go about this? Thanks in advance? Andrew

Hi Could anyone help with code to open my form in add new record mode? Thanks in advance Andrew

Hi All What event should i Use to update a subform which is based on a query to update when a new record is added? I am using me.requery but I dont know what event and what form it should go in??? Any help would be much appreciated Thanks Andrwe

Hi All I was wondering if somebody could help me, I have a form and I would like to add validation if a text box is null, not entered, a message to say that this is a compulsory field? Any suggestions or pointers in the right direction? Thanks in advance Andrew

Hi I have added the startup function within access, to open my form to edit data. When it now opens it automatically opens read only and it does not allow me back in to the start up menu to change this?? Any suggestions?? Thanks Andrew