Recent content by Lou

You should be able to use the date field from your query and put it in the Report/Page header with a description for what it refers to. ...Lou

I have a table of customers that is broken into 2 types of customers, specialized billing and regular billing by product. I can add an identifier field which gives me a specific to key in on. Does anyone know if the the color for specific records can be changed? I'm assuming that if it can be...

Try using as iif statement in the Control Source such as: =iif([beer_sales]>0,sum([beer_sales]),0) I am assuming that you are dealing with blank data fields. Hope this helps. ...Lou

Anne. After you have created the data table, you are going to need a table which shows, date, week, period, quarter, year, etc (depending upon reporting requirements). In a separate query, you are now able to group the info together based on fiscal week. I would suggest that you have the week...

What have you got in the tables? SIC, standard industry codes, are the only way. Post what you have on the board. someone else may be looking for this sort of stuff)I'm working with business names by SICs and MICs. ...Lou

I use the iif statement myself. Set it up as: iif(value=-1,"YES","NO") ...Lou

By the sounds of it you are using division. Use the iif command. =iif(x=0,0,y/x) However, if x is a function and is a/b, then you have to rework the equation to: =iif(a=0,0,y/(a/b)) Hope this helps. If I am not interpreting correctly, let me know. ...Lou

Been there........ The way that I circumvented the problem was to use a make table query which summed the data based on reporting requirements. My problem had been that without this, it was picking off each row, even though the query contained sum commands. Once I went to the make table, the...