Search results

Check your references (Tools -> References in the Microsoft Visual Basic editor screen). You should have a reference to the Microsoft DAO 3.x Object Library (x depending on your version, it's 6 for Access 2000). RV

There can be multiple causes for errors. If you did run into an error, post your code (if any) plus the exact error message. RV

As you will group on BusinessArea, you'll be fine ;) RV

Here's the correct link: http://www.fmsinc.com/ RV

Your query will look at the max date per row retrieved hence your result. Try this: SELECT id,date, max( day(date)) as maxday from fz_dates where month(date)=8 and date = ( SELECT Max(Date) FROM fz_dates ) Rename your column date as date is a reserved word in Access and should not be used...

Quite right. However sometimes you simply want a workaround ;) In this case you could argue whether the field is numeric or text, so no big deal. RV

You can create a query to do your subsets. You can either do your cals in the query itself, in a new query based on your first query, in a new query that joins your first query with your table. Depends on what you want, so try and see what best fit your requirements. RV

Lana, if you knowledge on VBA / SQL is very limited, I'd do what you did in the first place. As I stated before, you need to do this on each on every PC, as in, manually. RV

John, you can use a saved query in another query. You'll have to join your saved query with another table in your main query though. Queries are not processed from left to right. In fact, which column you put first doesn't make any difference. RV

I never do macro's but have a look at the IIF funktion ;) RV

Referring to my previous reply. RV

The use of the DCount function has been described in the forum quite often. So I suggest to do a bit of research yourself by using the serach facility. It's also clearly described in Access Help. RV

Yup, you can basicallly use whatever function you want. If your query throws up an error, it means that your syntaxis is incorrect. Check Access Help, all functions are described and will quite often come with an example. RV

Define your column as text. In your query, exclude N/A and I. Convert your grade column to a numeric string in your query. RV

You'll have to turn off the messages on each and every PC, as they are local Access settings. I'd suggest to use SetWarnings in VBA. Run a search on the forum if you need more help, topic has been raised before 'bout a zillion times. RV

You'll have to use VBA. Are you willing to start learning VBA? RV

Well, that's 'bout the same as asking me what will be happening tomorrow, and I ain't got no crystal ball ;) You better post your query. RV

DateSerial(Year(Date()),Month(Date())+1,15); RV

Check this thread http://www.access-programmers.co.uk/forums/showthread.php?t=113095 RV

Yeah, I know the score, I've been there too, helped me to get older and wiser. You seem rather committed trying to sort things out that should be sorted out in your opinion. Now if your company would share and appreciate your attitude, they would facilitate and accomodate you. Which, I guess...