Recent content by henrypotter

Hi all, I am still learning the reporting function of access. I am trying the chart function in report and unfortunately I can't change the default chart in the design page. What has gone wrong? Thanks, Henry

DCrake, Each quarter, I will get a list of car data from my coworkers. The price of the car may change, it may be sold, or we purchased new cars. Since he gave me the file in Excel, I was thinking to store his files in separate tables. There are more data fields than this such as location...

Thanks boblarson! >2. You shouldn't have tables that are date specific. Include a date field and fill it in. Why can't I have multiple tables for different dates? Sometimes I may need to track the particular car model prices from quarter to quarter. How could I write VBA codes to...

Even I got rid of the link it is still showing 125 records. All I want is 5 record showing the Color. Could you help please?

Could anybody help? Thanks!

Hi, I am trying to play around with query but got stuck in fixing the bug. Please see attachment. I am trying to link the color code from a table to another table which stores the definition of color code. However, it gives me duplicate results. In Excel, this could be achieved by using...

Sorry this is an extra question. if I want to put an extra conditional to eliminate emply Sex entry. What should I do?

If [sex] is empty, I want to change the cost to 0. So there are 3 conditionns. Should I write? NewCost: IIf([sex] ="Male",[cost],iif([sex]="",0,[cost]+500)) would access be able to recognize "" as empty?

Unfortunately, I cannot open your file since I am still using Access 2000. If [sex] is empty, I want to change the cost to 0. So there are 3 conditionns. Should I write? NewCost: IIf([sex] ="Male",[cost],iif([sex]="",0,[cost]+500)) would access be able to recognize "" as empty?

Ken, It's now working, however, I have some records that does not input MALE or FEMALE, I want to add 500 Cost to it too. What's the word for nothing in the query code? Thanks,

I did and the same thing happened.

Thanks! I tried to edit that statement in SQL view but it says "You tried to execute a query that does not include the specified expression 'iif (....) as part of an aggregate function. What does that mean?

Thanks. For my problem, you recommend me using Excel as the database and generate report using Access? I thought Access is better in handling data especially when I need to link two tables. What you are suggesting seems to be the reverse?

Thanks Ken. Where should I put these logics? in VBA or in query? or else where?

I don't have a form for users to input. All I want to do is to use existing field to calculate some results. Excel is very easy to handle this situation. Are you saying Access doesnot support that? but I am not very good at Access. My database comes strictly from Excel Data. Users don't...