Search results

Hi I have a query that divides two fields and returns the result to another field. Example: Table A: Field 1,Field 2,Field 3 Table B: Field 5,Field 6,Field 7 I have a query that joins both tables in a relations and now have both fields combined in the query to make one table. And i also...

Need some help again. How do i make a field in a report show or display zero if there's no value for that field. Currently the field i have just show blank when there is no data and i'd rather this show zero. I have checked the properties and i cannot find any function that has the name...

I am having some problems with my query, any help will be most appreciated. Problem: I have created a query from two joined tables example: Table A and Table B. Table A tend to have a field which when divided by Table B should create a new field with the result of the division. Example Table...

I am running croostab queries over a huge a mount of data and require only data that falls within a certain period. This period changes throughout the year (funny that) and the columns created by the crosstab in one period might not be the same in the next. My Problem; Other queries run off...