Search results

I am doing a transferspreadsheet method for a query result in access. I am exporting to the same file every time the method is ran. The problem I am having is I want the results to go to the same worksheet every time but I keep getting a new available worksheet whenever the method completes. ae...

Not sure if this is the correct thing to do or not but it works none the less. Originally i had two queries 1st to collect the data 2nd to sum the data To correct my problem i simply added a 3rd query using the the 2nd as my source. I then used the following formula to do my averages: TotAvg...

the scores have been entered as whole numbers ae: 196, 200, 234 etc. have already tried changing to double but no help. the totals are done in a query. i agree i think it is a rounding problem. I have tried the round() function but results were still the same. it was at this point my...

nope that didn't work either. Well I think Im going to do some more research into this some other time. For now I will use excel to make it right. Don't like to do that but you gotta do what you gotta do. I thank you for your time. I will repost if I find the solution. Thanks again

Thank you for your reply Tried the CDbl in both queries. Didn't work in select query. Got the SubQueries cannot be used in expression error in the sum query. Actually I am using the results from the query in a spreadsheet. I can make the fix there by adding another column. But I wanted to try...

Yes some of the averages are correct and some are not. The only common thing I can see is that the [Series] and [GameSum] fields get there numbers from another query and they are grouped by sum in the query i am having trouble with. Field: Series Table: qryWeeklyBlank1 Total: Sum Field...

Have searched but could not find my solution. I have a bowling league database and I am doing averages based on games bowled. On certain averages the results are incorrect. Such as Tot pins = 1169 divided by tot games = 6 the result should be 194.83 but the result in my query is 196 have...

Thanks so much for the help I tried both suggestions. When running the query I kept getting the expression was too complex error. Not sure why? So I changed back to my original expression in the criteria except I left the format at "mm/dd" as EMP suggested. Between Format([LaneDate]-3,"mm/dd")...

Thanks in advance Searched birthday in threads and couldn't figure this out. I have a select query and I am trying to retrieve a birthday that is between two dates. This is how I set up my expressions: chkBirthDay: Format([BirthDay],"m/d") Criteria for chkBirthDay Between...

Not sure what your looking for. But I have a form that begins on start up. This form allows the user to choose a season number from a combo box. Once that is done the form is hidden and all of my queries concerning any particular season the criteria in those queries is based on that form. Is...

Thank you for taking the time to respond I guess my next question is this. Is it common practice to start a new database by emptying tables? I think what you are saying is that in my case to empty the scores table and start a new season by copying and pasting a new database? Is this right? I...

Thank you for your response. I thought about doing what you suggested. Deleting the info every year and starting over. Correct me if im wrong but it seemed to me that was breaking the rules of normalization. (avoiding many to many relationships, duplicating data entry, etc.).I did look into the...

I have attached a word doc showing my table relationships. I would like an opinion on as to whether it is normalized correctly. It is for a bowling league that has 10 teams and 50 bowlers. The team names, lane assignments will change every year and the bowlers will be on a different team from...

Just wanted to let gunnerp245 that I have been trying to resolve this same issue for a week and this solved my problem. Many thanks..

I am using the outputto method to export an access report to excel. Theres no problem there except whenever i close the excel file i keep getting the message: WonLoss is a Microsoft Excel 5.0/95 Workbook. Do you want to overwrite it with the latest Excel Format. Is there a way to avoid this...

Thank you for your quick reply. The league consists of 10 teams bowling on 5 sets of lanes for 32 weeks. Each team will play on a different lane each week. For example 1 vs 2, 3 vs 4, 5 vs 6, 7 vs 8, 9 vs 10 on lanes 27,28,29,30,31,32,33,34,35,36. Correct me if I'm wrong but with normalization...

I am trying to create a bowling league db in access 2003. I believe I have started with the right structure but I am having some trouble with recording the scores of the bowlers. Attached in a word doc is how I have set up the relationships. Any thoughts would be greatly appreciated. D.J.

Using access 2003. I have a command button that exits the database as well as quit the application. docmd.quit worked fine in 2000. but now gives me this message in 2003. You Cant Exit Microsoft Office Access Now If your running a visual basic that is using OLE or DDE, you may need to...

I am changing companies and my db has been transfered to another server. It is opening in read only status. I think the reason is what Pat stated in example 1. The db was copied onto a cd and transfered to the new server. My question is how is this issue resolved. Do I need to dust off the DOS...

Never ceases to amaze me how simple the solutions are. Worked like a charm for me.