Recent content by BillyDo

Hi thanks for your reply. Sorry- I have not made myself clear. I made an error in my original post! The combobox should be populated from the venue table- but should update a 2nd table (Sales) Hope that makes it clearer!

Hi all Real newby question here but I cant seem to figure this out... I have a table (tblEvents) and I want to design a form which will be used to enter data into this table. I want the user to be able to select from a combobox (which will be populated from tblVenue). I can do this bit but...

Hi all I have an update query which runs as below UPDATE [All Sales] SET [All Sales].Charge= [Enter Update Value] WHERE ((([all Sales].Client)=[Enter Criteria])); So it updates an entered value in the Charge field where an enetered value is found in the client field. This works ok...

Hi thanks for your reply I should have explained that in the query- field A isnt Null or empty, it has a value. I want the user to be able to input a value, hence the []. Hours is a number type but it is a calculated field, which is why Access seems to be stopping me editing. Any ideas...

Hi all I am trying to use an update query to update a field in another query. However I am getting an "operation must use an updateable query" error. After a bit of research, I think this is because I am tryin to update a calculated field. Is there a way around this? Many thanks The SQL...

Hi all I want to run some sort of update query which will update a particular field in a table based on 2 criteria. I dont know how to write the statements in Access but it would be like this; In TableA- If Field A = “Red” and FieldB = <100 Then Update Field C to “Green” Is this...

I have 2 queries- QuerySalary which totals an employees monthly salaries, QueryExpenses which totals the employees expenses. Not all the employees have both expenses and salary so there are some blanks in the data. I have set up Query3 which I want to total up the totals from QuerySalary and...

Thanks again Do you know an expression I can now use in the query to calculate the difference in hours between the earliest and the latest times?

Hi all I want to build an update query which will update data in TableA I want the user to enter a parameter to look for a value in FieldA. If that value is found then I want the text in FieldB to be automatically updated with a numeric value from a 2nd user entered parameter (for example...

Excellent- just what I needed. Thanks a million for your help

Hi, thanks for your reply. I should have explained that in the reference field there is a 3 digit number. There are duplicates of the reference field though- so the data looks a bit like this Reference Start Finish 100 10am 2pm 100 11am 3pm 100...

Hi all Wonder if anyone can help with this one. I have a database for managing event bookings. Here is a simplified version of the table structure TBL:Events EventId (PK) Reference VenueID (Linked to TBL:Venue) Date StartTime FinishTime TBL:Venue VenueId VenueNAme I want to be able to...

Hi all I have a very large amount of data in an Excel spreadsheet (dummy version attached) that I am hoping to import into access. It relates to the provision of meeting facilities by external organisations. The data is arranged in an unusual way as it has been exported into Excel from an...

Thanks to anyone who has helped with this. I dont feel like I explained properly what I want to do and dont want to keep bumping the thread here. I have therefore created a new thread over at another forum which I want to put a link to here out of courtesty to anyone who might be looking at...

Thanks a lot for your help, I do agree I need to restructure my tables. I should have explained that my sales table will have quite a lot of data imported from a spreadsheet (I know how to do this) however the cost of the purchases will not be imported. Therefore I am looking for a way of...