Search results

Your not being stupid, I still fumble around trying to figure things out. :D I think you may need to add the additional fields into the "GROUP BY" line like so: SELECT adverts.id, adverts.title, adverts.name, adverts.url, Count(adverts.url) AS TitleCount FROM adverts GROUP BY adverts.url...

Not sure if your interested but I found this sample database a while back. It's for A2k. I also have Access 97 and Access 2002 database as well if you like.

I always run the compact/repair database utility from the Tools menu. I've never had a problem doing it this way and yes you can have the database open during the process. I guess I'm not sure why you want to set up code for it. :confused:

I'm sorry, try Count([adverts].[title]) I forgot the parenthesis

Try something like this to get unique adverts.title and count # SELECT adverts.title, Count[adverts].[title] AS TitleCount FROM adverts GROUP BY adverts.title ORDER BY Count[adverts].[title] DESC; I think this should work.

If you ever feel the need to read about or discuss your favorite #2 business then this site's for you. http://www.poopreport.com/

Thanks for the reply. The more I'm looking into this I think the problems I'm having are turning out to be datafill inconsistencies with the table I'm querying. The query and sql that I've written is correct but I need to go through the table and make sure that the data is correct so the query...

I'm running a simple bit of code to delete the contents of a table and then populate the table based on a query. The problem is when I run the query I get 776 records. When I run the code to populate the table with the query then I only get 771 records. Can anyone help me to understand why...

I've written some code to write some query results to an excel file but I'm getting an extra file saved that I don't want. I have my database located in "My Documents" but the pathname of the file that I'm trying to save to is different. When I run my code it saves to an excel file based on my...

Thanks Pat, I guess it didn't look right visually when I looked at it.

Thanks Hayley, I just found this and it really helps me out! :)

Surjer, I think that's what I'm looking for. Figures that it's something really simple. :rolleyes: Thanks. :)

Ken, I'm sorry I mis-stated my question. I didn't mean a single quote. What I what is a constant or variable that is one single double quote. I want to add double quotes around a variable but don't know how. For example, I want to turn this: strString = Word into this: strString = "Word"...

I don't remember if there is a way to do this or how to do it but I'd like to declare a single quote constant but I don't know the correct syntax on how to do this. For example, if you declare a regular double quote constant it is done like this Public Const Quote As String = """" what I'd...

I had a pretty good laugh with this: http://www.ratedtoons.com/marthasway/index.cfm **FYI, not appropriate for the workplace unless you can get away with playing it. ;)

What if you just right click on the program file and select "Create Shortcut" and just cut and paste the newly create shortcut onto your desktop.

while wearing speedos

As to why this is occuring I don't know but I've had similar problems before. I would just create a new qryStartSubReport and try your "if statement" in the new one. If that doesn't work then it's beyond me. Sorry I can't be more help.

That's interesting. I guess it doesn't necessarily pay to be lazy huh? ;) Fortunately, the code that I usually run isn't that intense. I've also been trying to take a lot of people's suggestions and try to run more and more stuff through saved queries rather than code. Cheers! :)

ReAn, I'm trying to follow what you put and I think I understand it but do you know which of these is faster: Example 1) If x <> y then s = r Else s = t end if or Example 2) If x <> y then s = r If x = y then s = t Maybe it's poor practice but sometimes I've gotten into the habit of...