Search results

This is basically right. You just had your ">=" and ">" backwards in the last OR statement. SELECT (SELECT Count(*)+1 FROM tblTeams t1 where t1.points > t.points or (t1.points >= t.points and t1.goaldiff > t.goaldiff) or (t1.points >= t.points and t1.goaldiff >= t.goaldiff and t1.goalsfor >...

Try this: SELECT Team, Points, GoalDiff, (SELECT Count(*)+1 FROM tblTeams t1 where t1.points > t.points or (t1.points >= t.points and t1.goaldiff > t.goaldiff)) as Position FROM tblTeams t ORDER BY t.Points DESC , t.GoalDiff DESC; It may not look pretty, but it seems to work pretty good.

Remove DatePaid from the SELECT statement and add GROUP BY for the fields other than AmountPaid. SELECT Commissions.TransactionID, Commissions.OriginatorID, Sum(Commissions.AmountPaid) FROM Commissions WHERE ((Commissions.DatePaid)> DateAdd("d", -32, Date())) GROUP BY...

Nevermind. I figured it out. I do have a second problem though. When I go to a new record, the information that I typed in the unbound textbox is st5ill there. Is there a way to erase that everytime I go to a new record?

I have a form where I would like the user to re-enter the same information twice and return an error message if the confirmation does not match the origianl entry. I have the first field bound and the second one unbound with an If/Then clause tied to the AfterUpdate event of the field but I...

Thanks Raskew! That worked well for the records that had commas in it. I did have quite a few records with no commas though (you gotta love those data entry people). I figured out how to extract the city from those records though. Thanks again!

I have a field that contains a city and a state (ie. New Orelans, LA). I would like to find a way to strip the state out of the field, put it in another field, and leave the city in the original field. Is there an easy way to do this? Thanks in advance.

I have two tables with bank account information in them. One has the account types spelled out (Checking & Savings) and the other has just the first letter (C or S). I am trying to make a query that compares the two table and gives me anything that is different. How do I tell Access that...

Thanks RV. I'll give it a try. The reason I have 15 queries is because I have 15 employees that have a query assigned to each one of them. Each employee gets a certain chunk of work based on certain numbers assigned to external clients. The 15 queries don't cover all client numbers, just the...

I am trying to make a query that will show records from a table that aren't shown on a series of other queries. There are 15 other queries that pull different records based on the field "Client #". Each query pulls a different series of client numbers from the same table. The final query should...

Is it possible for me to send a report to multiple addresses with each record of the report specific to each address?

Is there any way to automatically update a field with todays date if another field has been changed? If yes, will it only work in a form, or will it work if you are updating info in a query and/or a table? Thanks in advance.

I have a javascript from a website that I would to implement into an access form if possible. The javascript consists of a formula that validates bank routing numbers. Is there an easy way to implement or convert the script to a usable format? The code follows. Thanks in advance. function...

I have a form based on a query and I want the form to show me the first ten records that match the criteria of the query. Is there a way to do this? On a similar note, if I am able to have the form show the first ten records, can I have the form prompt the user for his/her name and have the...

I have a table (TBL-Today) that I need to copy within the same database with a different name (usually TBL-yymmdd). I usually just copy and paste it and give it the new name. I want to make a macro that will copy and paste the table and automatically give it name based on todays date. If that...

Thanks a lot Pat! It works great.

Is there a way to have a macro assign and/or remove a primary key from a specific table?

I am trying to change the field names of a table that is created from a text document that I import into Access. The field names are set to F1, F2, F3, etc. I was wondering if there is some way to have a macro slap specific names on those fields.