Search results

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 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...

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...

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...

Hi everyone. My first post and a very newbie question to ask. I have attached a database (extremely simple) to help explain what I mean. I have a purchases table which I want to use to record purchases from our suppliers. I also have a suppliers table which appears like a matrix. It lists all...