Search results for query: *

aargh, you are quite right, its the wrong one. not my morning. I will dig out the other one and apologies for being a complete plank..

thank you !! SELECT calcStudentRecahrges1.[Student Name], calcStudentRecahrges1.[charge type], Sum(calcStudentRecahrges1.Expr1) AS SumOfExpr1, Students.[Pupil Code] FROM Students RIGHT JOIN calcStudentRecahrges1 ON Students.[Pupil Name] = calcStudentRecahrges1.[Student Name] GROUP BY...

PHV - Repinfo has one line per salesperson, sales has many lines. repinfo is basically just name, id, manager, contact details where sales is all the sales records. Skip, not sure how to post a query in here other than to describe what it looks like, (eg two tables in top of screen, criteria...

Sorry, that is the info from the original table (sales), I am then adding that table, and another table (RepInfo) into a query and trying to add the salesid from that 2nd table (RepInfo)onto my query. So from sales i have - Salesname, sales region, ammount and from repinfo I have salesid, area...

when i created the table I chose a look up field type and choose the salesname field from sales through the wizard. so the SQL for the row source is - SELECT [sales].[salesid], [sales].[salesName] FROM sales; Im wondering if it would be easier to make a new table and start again but i dont...

Ok, I have a table which has a field populated from a lookup in order to limit to list so only staff on the list can be added in. Im trying to create a simple query which totals up sales from each member of staff by region, and adds in their id code which is not in the original table. Every...

Apologies Im slowly getting back into using access again and finding Im struggling even with basics and everything is a bit different in this version of access. I have a report, it looks at a text box on a menu form to get its critera of a site number and generates the report for that site...

We have a list in excel (2007)which has photos inserted into it. I need to print the list including the photos but when i print the images are not lined up with the cell they appear to be in in "normal" view. I have tried setting properties to move and size with cells but that makes no...

Wonderful !! Thank you so much, that is going to make my life hours easier

Hi, sorry, I'll try to clarify. I am trying to produce a timetable of activities in an easy to follow format from a complicated spreadsheet issued to me weekly (which i can then import into sheet B) I dont want to spend ages re formatting it each week so I was hoping to be able to work out a...

I have 2 worksheets. for the sake of simplicity called A and B. I wish to check the contents of cell C8 on A with C36 on B, if they match (text) I want to then check if B6 on A and D17 on B and see if they are equal, if yes then see if cell D36 on B is a "y" if all that is correct I then want...

Thats great PHV thank you !!

Im sure there must be a way to do this but cant think what it is. I need to be able to get the user to enter a invoice number, I then want the number to be stored against all records that have a yes in the "sold" field and nothing (blank) in the "invoice date" field. Any help hugely appriciated !

Thanks Skip !!

thanks Skip, Im trying to make something for someone else to use while Im not here and they arent very familiar with computers so I was wanting to make it as quick and easy as possible for them. No worries if you dont know a way to code it I'll see if I can send it to my pc and hyperlink it...

Thanks both for your replies, does it make a difference if im using excel for mac ? I can hyperlink to a document rather than website and I can select the document I want (the one im in) but I cant then select a specific worksheet in that document ?

no i dont want to open a document, i want to open another worksheet in the same document, hyperlink is not giving me that option ?

I have 80 rows in a worksheet, I want to be able to click a specific cell in each row and for that to go to a specific worksheet. very grateful for any idea on how to do this thanks in hope

Thanks PHV I cant believe i didnt think of that but i didnt. It is now working and sorted fine

I have some code very kindly given to me in thread 705-1142361 It has been working perfectly up to now but following some changes to the import files and therefore to the table that they import into now come up with an error message "Failed to Import File " (as you would expect) code- Function...