Search results

I hope I am not trying to accomplish an impossible task.. However, I want to combine 2 queries that give different results. Please see attachment with the task I am trying to accomplish showing the queries and the results. Thanks for any suggestions please.

Thank you very much guys. I can now edit my query

This might have been around for a while because I restored several backups, even end of year 2009, but the same problem. Can we edit the query any other way? Thanks for all your help.

Yes, I have a backup but I didn't delete any fields.

Thanks for such quick responses. When I right click, it opens the query with the error message. When I click OK to close the error message, it also closes the query.

No. Please how do you open in sql view?

I have a query that is used to generate a report. When I try to open the query design it gives a message that 'there is a missing ),] or item in query expression'. When I select OK it exits the query. I also tried accessing the query from the report properties, but same problem. How can I...

Hi Pbaldy: I have been able to sort my coding out. I now have the query working just fine. Thanks guys

Hi Pbaldy: Thanks again. I do appreciate your quick response. I had a field spelt incorrectly. So the error is gone. However, It seems as though TOP 1 is giving me the field from the first record in the table for that salesman. What I want is the field from the last record in the table for...

Hi Pbaldy: Thanks. I tried your code. I am getting a Run-Time error '3061':Too few parameters. Expected 1. The error is on this line : Set rs = db.OpenRecordset(strsql, dbOpenDynaset) Below is the code I am using reconid in the SQL statement is the primary key for the table 'tblrecon'...

Thanks guys: I am really trying with Access codes. I just want to give you a bit more information about my scenario. For example : I have a table with 5 records ( as shown below). When I open my blank scoresheet form to add new scores, I will select the name Sue. On this form I have a field...

First I will open a form and choose a salesman. Then based on the salesman selected I want to open a recordset and start searching for the last record for the salesman selected. When the record is found some of the information from that record is pulled on the form.

Access 2000: I have 8 salesmen selling the same 10 items. I also have a sales table with each record showing: (date, salesman) - and for each item (opening stock, sales, closingstock, qtyreturned). To open the daily sales form I first select the date and then the salesman. I have to key in...