Search results

Sorry for being a numpty CJ, but I'm doing this in a query using the build button. Whatever I try I get a syntax error. The field names are [Pulse Value] - [SWFAL Mkt Value]/ABS [Pulse Value]. Ive tried it with your equation but to no avail. Cheers Mark:banghead:

Hi All I am trying to set up a calculation between two values to show the percentage difference. In Excel, for example, I would have two values, £905,175 and £891,563, and I would enter =A1-G2)/ABS(A1), which would then return a plus or minus percentage value. Any ideas how to do this in a...

Thanks for the response. Even though the file is on a shared drive, I can only open it read only, and when I do, the fields I need are shown as #NAME?. An example of the fields in question would be =BDP("XS0735451022 Corp","PX_MID"). So, even with the workstation being switched on and the...

I did try that, by replicating exactly the functions contained in his spreadsheet. However without the add-ins that will only work on a station with a licence, it doesnt return anything. It costs a fortune for a licence and I dont have one! The workaround is not ideal, but it does do the job...

Hi All I have been working on a stock & share reconciliation process, which was originally carried out manually, by looking at three separate reports and ticking them against each other to spot any differences in quantity of shares and their values. I have imported the three Excel files into...

Damn! The FM links his spreadsheets to a system called Bloomberg, so he can see updated prices & values, and which requires Excel Add-ins. This means I cant see this info on my PC. The solution is a manual one: save a copy of each spreadsheet and manually import that into Access. :banghead...

Thank you for your responses. I think I might be on the right track. I have to pull a total of 21 data sources, either in CSV or Excel format, from emails and an external system download. At the moment someone sits down once per week and does a three way manual tick-back from each source...

Forgot to mention - using Access 2010

Hi All I am currently in the process of automating a stock & share reconciliation process, where there are three different sources of data. Two are emailed in to me, and which I have written macro's to import. The third source comes from a spreadsheet, which I want to be able to write a...

I have an invoice system, where the payment due date is the last working day of the month following the invoice. For example, if I produce an invoice on 5th June, the payment will be due on the last day of July. Any ideas what I can put in a text box to automatically calculate that date...

Sir, you are a genius! Thank you very much;)

Hi Mihail I'd be very grateful. Attached is a copy of the database. Just go into Invoices, and print, then a copy of the invoice will appear and you'll see what I mean..... Many thanks

Thanks Mihail. Did all that, but still no result. I think it may be because the sub report is directly from a form, not a report. Is ther any way to do this within the sub form?

Hi All I have a database, in which I have three tables which hold 'static data', which will be used over and over again to record work and produce invoices. The Tables are as follows: tblManagedUnit MUID (Key) (One to Many with CircuitName below) MU Number tblCircuitName CircuitNameID...

Hi Again After a few hours sweating, I think I have the structure complete, but that's my own opinion! I now have to incorporate these tables into one input form. Is the best way of doing this via query/form/subforms, or is there a better way of doing it? It would seem I would have a fair...

Thanks Jdraw. It does look different to mine, but thats probably because mine is way off the mark. I'll work on it & let you know.

I have split the two invoicing tables. Do you think this is better than the first?

First of all I would like to thank all of those who have guided me along the way. This is the best site I have ever had the privilege of being a member of. My learning curve is still on the upward! I would, once again, be grateful for some advice. I am at the planning stage of designing a...

Many thanks. I guess I need to create the equivalent of an 'orders' table to handle each invoice, so that when, for example, a rate of charge changes, it will not change any underlying data on an already issued invoice? Do you think I'm on the right track?

Hi All I have a database for tracking jobs & producing invoices. The 'static data' is of course linked to each invoice. I need to create distinct transactions for each invoice, so that if the static data changes, such as rates of charge, it will not automatically update any history, where a...