Search results

Thank you, that sounds like a very logical approach. rbrule

It would be a text field in Access, if I could import it, however when I import the excel sheet the data type is grayed out and it shows as Double. How would I make the change prior to the import so that it imports as a text field?

Hello, I have been trying to import an excel sheet into access. One field continues to be a problem. Half the data in the field winds up on the import error list, because of a type conversion problem. Half the data are clear three digit numbers and the other half are alpha numeric. The import...

Hello, I have a report that shows dollars earned for each month of the year. It is based on a crosstab query. The report shows not only fields with dollar amounts in them, but also blank fields, because each field has a border. I would like to show only those fields that are not null. I have...

1 Check your garages table in design view to determine if the spares field is marked as a key field. A little key will be next to the field name if it is. 2 If it is not marked as a key field, highlight the field and press the little key on the menu bar at the top of the screen. That will make...

1 Check your garages table in design view to determine if the SPARES field is marked as a key field. A little key will be next to the field name if it is. 2 If it is not marked as a key field, highlight the field and press the little key on the menu bar at the top of the screen. That will make...

Thank you Andy, It worked perfectly. rbrule

Hello, I have a report that shows dollar amounts for each month of the year. I want to make the month fields visible only when the field is not null. I understand that Access 2000 requires VBA code to setvalue, instead of a macro. I tried setting up a macro, but it did not work. I then...

Thank you very much for your help. I finally got it to work. I must have been typing something wrong.

I am sorry to be such a knot head, but I tried both of the last two scenarios and I get an error message that says "The expression you entered has a function containing the wrong number of arguments." What might I be doing wrong?

Hello, Your expression brings me to last month (January), but doesn't distinguish between last month this year, or January in any previous years. Is there a way to refine it? Basically I need the expression to refer to the month immediately previous to now. Thanks rbrule

Hello again, I am now creating a calculated field in a query which draws data from a month previous to the current month. For example, IIf ([mfg]=a and [date of sale]= any date last month, 250,0) How would I express " any date last month" so that the results would allways be automatic. rbrule

dcx693 thank you so very much! You don't know how much easier you just made my job. Your example worked perfectly for the problem I had. rbrule

Thank you, that worked fine. Is it possible to continue the expression with a different conclusion for different circumstances? If so, how would I do that? I tried reentering the IIf statement after the parentesis using an "or" with different criteria, but it just wiped out the results of...

Thank you, but since I don't know VBA, I'd like to stick to the IIf statement if it is doable. However I do have a couple of questions. How do you note the values in a list? For example [mfg}= A or B or C. I tried this using "or" and "in()", but neither works. Also how would I duplicate the...

Could you tell me how to do it? I have no clue. I don't know VBA rbrule

Help with expression in a calculated field Hello, I need to create a calculated field in a query that calculates a commission, based on a particular [manufacturer] and a [dollar amount] sold. If the [dollar amount] is between x and y and the [manufacturer] is A,B,C,D the commission is a fixed...

Thank you very much. I appreciate your help

Hello. I have a table with two important dates, Date 1 and Date 2. I need to query only those records for which the difference between date 1 and date 2 is greater than thirty days. I created a calculated field and subtracted date 1 from date 2 and used the results for the criteria in my query...

Thanks again Pat: It worked fine. Now I need to set up a suitable report. If I have a problem, I'll be asking for help again. rbrule