Recent content by oklahoma84

The one field is just empty for this one set of records. Can you help me with the isempty expression? Where would I put this?

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...

Ok i did link every field that was common. They still repeat buy now only like 5 times instead of 250 times. Is it something to do with the 5 months. Any other suggestions? Thank you!!

Ok. How would I link these together? Thank you so much for your help! I am not a computer person!!

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?

Well the data in each table is the same just for different years. One table has this years data, which i am using the whole table. The 2nd table is prior year spending information, which i am just using one column out of this table. There is no duplicate information in these original tables...

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?

When i tried that it states "the text i entered is not in the list" Can you help?

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!!

can you walk me through that?

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!!

Thank you so much!!

how do i get to the group footer? one does not appear in design view

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...