Search results

Thanks Paul. This worked much better than my IIF statement. I still couldn't get IIF statement to work. Thanks for all the time I saved. Have a good weekend!

I tried your suggestion; however, now I'm receiving an error message: The expression you entered is missing a closing parenthesis,bracket or vertical bar. I added a parenthesis at the end. Any suggestions?

I want to convert my dates to months so I added the statement below in the Field section of my query. It is not working. What am doing wrong...

what is a junction table? what does fld stand for? field? I'm having trouble with tbl CompanyProgram. Please see my sample

What's the best way to setup this db? I have the following information: Company Company ID Program A Program B Program C Program D 2000 2001 2002 2003 2004 2005 The years indicate the year the Program participated in the company. For example, Program A participated in Company Z from 2000 to...

I solved the problem. Attached is the revised sample. I used a group by and expression. I hope this will help someone else. Have a good day!

I've attached a sample of what I'm trying to do. I want to count the number of hits in the column (each number represents only one hit). For example, Bill had a total of 2 hits. Please help me count the hits. Thank you.

I want to divide d8/b8; however in some cases d8 might be 0 or b8 might be 0. If either d8 and b8 = 0, I want a dash. Found solution: =IF(ISERROR(d8/b8),"-",d8/b8)

Problem with multiple reports I couldn't get the sample.mdb to work. An error message popped up: "Can't find project or library". What did you do to fix this problem? I'm unable to get this to work. I also have a report with multiple pages and want multiple power point slides. Were you able...

Danny, Would you mind sharing your questionnaire db with us? Thank you.

THANKS KEN I thought I needed to put the * since I did not know the time. Guess not. Thanks! Have a great day!

How do you query date/time? I have a field with date and time, e.g. 4/2/2004 5:12:33 PM. I want to query all records before 4/2/2004. When I type < 4/2/2004*, I get an error message. Any suggestions? Thank you.

How to avoid duplicate records?????? Try this In SQL view after select type "DISTINCT" Good Luck.

:p Hi Brian from the Microsoft.public.access.queries was able to resolve the problem. Here is the solution :eek: SELECT [Total Freshmen with Total Academic Score].PERSON_WH_ID, [Total Freshmen with Total Academic Score].[Total Academic Score] FROM [Total Freshmen with Total Academic Score]...

Try this website http://support.microsoft.com/default.aspx?scid=kb;en-us;208946 Good luck! Dona

TOP 100 and Ties Thanks Neil it works this way. Do you know why it doesn't work WITH TIES? See below: SELECT TOP 100 WITH TIES [Total Freshmen with Total Academic Score].PERSON_WH_ID, [Total Freshmen with Total Academic Score].[Total Academic Score] FROM [Total Freshmen with Total Academic...

John, Here's the query, I originally used. SELECT TOP 100 [Total Freshmen with Total Academic Score].PERSON_WH_ID, [Total Freshmen with Total Academic Score].[Total Academic Score] FROM [Total Freshmen with Total Academic Score] ORDER BY [Total Freshmen with Total Academic Score].[Total...

The query still returns 100 records. It is not returning the ties. Here's my query. SELECT TOP 100 zztab.PERSON_WH_ID, zztab.[Total Academic Score] FROM zztab; Any suggestions? Dona

I want to query the Top 100 scores; however, I want the ties, too. For example, number 100 has a score of 7490. I want to include the additional 5 records with a 7490 score. This would make the query return 105 records. Is there a way to do this without using "Select Top 100 with ties"? How...

save/exports Mike Yes, you can bring an ACCESS report with a chart into PowerPoint. My report had multiple page charts and I was able to bring it all into PowerPoint. Go to Report Select your report Right click Select Export Type File Name Select save as type: SnapShot File Next Follow...