Search results

Hello, I am trying to create a bar graph that shows income, month, and year. I created a graph using the chart wizard, an it almost came out the way I need it to. I have the statistics on the left hand side, the year(s) on the legend on the right hand side and the months along the bottom axis...

Thank you for your help

Hello, I have a report with a company logo on it. When I convert it to rich text format in order to email it, the logo disappears. Is there a way to correct this problem?

Try compacting and repairing the database. Adding and deleting objects increases the size of the database. The compacting process cleans it up and reduces the size.

Thank you Jon, I appreciate your help.

Hello, Is it possible to compare two fields in a query, and pick out only those that don't match? If so how would I go about doing it?

Hi DBL, thank you for your response. I tried the above expression, and I am still having a problem. The expression returns the contents of each field to the calculated field. If [field one] [field Two] [field three]and [field four] each have contents, then the contents are also copied to the...

Hello, I have four fields in a table with the same type of data that I want to combine into one. As a result I have set up a calculated field in a query. Some fields in the table are null and some are a zero length string. I used the following expression, and variations thereof, but it doesn't...

Thank you for your input

That is my dilemma. There are similar fields in both tables. I joined four fields of the same type in a query and got some results, but I am not convinced of the accuracy. I tried to make a table from the results but access would not let me. Do you have any suggestions?

I recently received information on how to create a junction table, and I thank those involved for their input. However, both scenarios involved creation of the junction table and the host tables from scratch. My problem is I have two tables with existing data that I need to link. How do I...

Thank you for your help. rbrule

Thank you very much. rbrule

There are 11 threads in the sample databases section and none are entitled many to many sample db. Can you send it to me?

Hello, I have two existing tables with related data. Neither table has unique field that can be used as a Primary key field with a corresponding field in the other table. I need to relate these two tables so I can extract certain data from each, in one query. How do I create a "Junction...

Thank you, I appreciate your help. rbrule

Hello, Recently I created a report with text boxes that were visible only if not null. I also made the page header labels invisible if the detail text boxes were null. This worked fine when dealing with records of the current year. When combining records from prior years, I noticed that the...

Thank you Pat, it was a zero length string and responded to ""

Hi Rich I didn't use quotes around the Is Null. The data type is text. I have used Is Null as criteria many times with no problem, in other queries. I don't understand what could be wrong.

I have to create a query in which, I know several fields are blank. In the criteria of the particular field I typed "Is Null". The data sheet showed no records, when I ran the query. When I run the query without the criteria I get all the records. If I put criteria in another field it filters...