Recent content by david.paton

In response to post 19, you say to import the data to a table in access CJ but should I put it in one table as there will be data from about 7 spreadsheets, each spreadsheet has 12 sheets for the months of the year and each sheet would have anywhere between approximately 100-400 lines. Would...

With the previous questions of how I should I link it, I want to search through every row in the table or multiple tables and return every record that matches a search string. Should I import every row from each sheet into one table in order to be able to search through them or do i kink to the...

How should I link to all the data. Should I import it to access from my workbooks or should I link to the files? Also, if I import, is there a better way then manually importing every sheet?

My supervisor has agreed to have this search tool only analyse the allocation sheets from past years that have already been closed off and will not be changed. Therefore, they will all have the same format. My supervisor wants a query tool that is able to query the past data for decision making.

Come to think of it, there is only 2 layouts for the allocation sheets that will be used and I know the layouts, so I guess there will be some consistency. They will be from either the old format or the new one I have created. Does this make it any easier?

There will be 2 people that update the allocation sheets. I just need to focus on what has happened in the past at this stage so there will be 17 documents. I have some further understanding of what is needed now. I want to search through the workbooks and find rows that have a match somewhere...

I think I had a different understanding of these documents as to what was needed. Entries will be copied to the allocation sheets and may need to be edited during the during the month. However, on the 25th of each month, an invoice will need to be sent for the current month, made by...

Re: I need a little direction in starting my project Sorry if I was confusing in my definition, I will try and be as specific as possible. I have x number spreadsheets called allocation sheets for x number of financial years. The spreadsheets record one of about 6 activities between...

For every month in the allocation sheets, the header row is in row 3 and the date starts in row 4.

I need a little direction in starting my project I have spreadsheets called allocation sheets. These are yearly documents and each row is a service instance. The row headings are: Date Purchase order # Req # Child Name Service Requesting Organisation Caseworker Name Price ex. GST GST Price...

I just found out how to do it, I used the date formula =DATE(I30,1,1), where I30 is the year, then the month and day of month, for instance, the above example of new years day.

The list of public holidays is almost created, I only have one bit left to make. Any ideas how I can do this as I think I am now over thinking things. I have various public holidays that are on a set day, such as new years day 1,1,xxxx or christmas day 25,12,xxxx. How do I input the current year...

Figured it out. I used =FLOOR(DAY(MINUTE(I30/38)/2+56)&"/05/"&I30,7)-34 where the year is in I30. I have a cell with the current date in it: I29=NOW() and a cell that works out the year from that date: I30=YEAR(I29).

This appears to work. I now have a list of holidays for Australia and I have a row at the top of them that contains the current year. It needs to reference a cell, A5 in your example. I am using I30 in my spreadsheet and I was thinking I could add some code that would enter the current year into...

So let me get this straight as it doesn't seem to work for me. I tried to follow the insturctions on chip pearson's site and it gave me a massively incorrect date. I tried this excel function from the page http://www.cpearson.com/Excel/easter.aspx...