Search results

I have several tables with different infomation in them. When i join them in a crosstab query, it leaves out data that is not available in all fields. How can i get it to leave blanks in these spots and include the rest of the information. i.e Dept subaccount MTD YTD...

When i make a table into a crosstab, there are blanks displayed. How would I use the Nz function to fix this, or is there another way?

I have imported data from excel into 2 separate tables. I made a query using these 2 tables and then from this i made a crosstab. In the crosstab for some reason it duplicates the same information over and over to where 5000 records become over 100,000. What is going wrong?

I have monthly data in a crosstab query. In some months there is no activity for accounts. I would like there to be a zero in these blanks. I think i need to use the NZ function but I do not know how. Can someone help me!!

New problem each day! Ha. Ok I have a crosstab query with data in monthly columns for various accounts. For some accounts there is data in jan and march but not feb. Is there a way to get these blanks to be 0 without manually adding them? Thank you!!

Hey I am needing to sum columns in a report. The report is taken off a crosstab query. I tried putting =sum([YTD]) as a text box in the page footer section. That could totally be off. Where am I going wrong? Please guide me through this!! Thank you so much!!

:eek: I am making a database with tables that have the spending activitiy for each subaccount in a department. When I made a query only the records that had activity each month were displayed. For example, if account 110 had activity for Jan, Feb, and April it would not be displayed in the...