Search results

sorry for appearing dense but could you elaborate on your last post as i am unsure on how to go about inserting the do-loop into the code. Thanks.

Hi Col, Thanks for the reply but when I implement the function in a query it ignores any criteria specified by the query and just returns the total for all records in the dataset. What am i doing wrong!! Thanks again, Alan

Hello, I have copied the below code from either this site or microsoft's access help pages and it is doing exactly what it should. My problem is that i need to add an extra parameter to it but i am not sure how. Basically the code is summing the field DURATION which is a date/field in the table...

Hello, I have, with the help of this forum modifed some code that now returns a list of dates in sequence compiled from a start date and repeat count entered by the user. My problem is this - the output provided the dates as one record, is there any way that these values can be stripped and...

Thanks for the reply. In the end i resorted to creating the recordset in excel and linking my db to the spreadsheet. cheers

Hello, I have a form upon which I have 2 activex date pickers bound to startdate and enddate. Alongside these activex controls i also have text boxes bound to the the same fields. Once the date is selected via the date picker the text box will update and display the chosen date - but only after...

Hello, I have a table with 2 fields - WeekID(autonumber) and WDATE(date/time). What I want to be able to do is to enter a value for the first date and then have the next 25 entries automatically entered. Each entry is to be 1 week greater than the previous entry. Ultimately giving me a list of...

Thanks for the reply. I was able to solve the issue using the INDIRECT function as you mentioned. I entered the code and used the fill handle to copy to all required cells Below is example of code used for any others with similar issues. Thanks =INDIRECT("'booking ledger'!$A$"&ROW(2:2))

Hi, i have a problem whereby i have 2 worksheets and the data that is entered on sheet1 is automatically dropped into sheet2 by means of ='sheet1'!A2..........'sheet1!Z2' etc being entered as the formulae in the relevant cells. The problem is when rows are inserted into sheet1 the values are...

i have a query that limits the search results by their date. i have a form that has 2 date/time pickers both bound to a field start and end date respectively. The query criteria for the date is "Between [Forms]![frmMain]![StartDate] And [Forms]![frmMain]![EndDate]". This works fine except for...

the period filed needs to be represented as a number 1 - 12 as the it is used in conjunction with another field called year - year is entered as L (last); C (current); N (next); this is the structure that the accounts software uses. The users will choose both a year and a period so C and 5 will...

I have a database that allows an accounts department to reconcile data. I have a table that contains several fields, two of which are date and period. What i want to do is update the period pending on the date - i.e. if the date is 10/05/2005 then the period is to be updated to 5; 10/04/2005 to...

re: splitting up data sample data attached. thanks again

i have a linked table from which i run an append query to produce a list of customer addresses. However the address appears in one field i.e addressline1 addressline2 etc and when displayed on a report it looks poor! is there any way that i can split this data out into 3 or 4 fields so they are...