Search results

Thank Tanis for the spelling correction. I will look into the mailmerge

Sorry Pat. We were on the same topic I just figure I ask him a quick question

It worked!! You are really good. But the only problem is when I look at the report it does not display it all. I made sure the box on the report is big enough to hold the text but not all of it is displaying

Below is the text I want to have. Where it says son/daughter is where I want the "code" to go: Due to the change in your son/daughter schedule, there is a change in the required textbook(s). Therefore, we request that you go to your textbook supplier with this letter and obtain and/or return...

Another quick question, I want to put that piece in the middle of some text into report. What is the best way to do it?

Thanks!!!!! It worked perfectly. Your the best!

When I put that Line in expression IIf([Sex]="M","Son ","") & IIf([Sex]="F","Daughter ","") nothing comes up. But should I be putting it up under critiera?

The Field says Sex, underneath it, it will have either a M or F next to their name. It does not refer to parents. M/F does not refer to anything. Is there an expression where I can write to translate M into Son and F into Female?

Sorry I wrote this in the wrong place, I put it in Report Forum. But if you can help me out that would still be great.

I am creating a letter in a report for parents. In the report I want it to figure out whether it should say son or daughter. I do have a field for sex (M/F). Is there a way to tell the report to say son or daughter base on the sex field?

I am creating a letter in a report for parents. In the report I want it to figure out whether it should say son or daughter. I do have a field for sex (M/F). Is there a way to tell the report to say son or daughter base on the sex field?

Can you append to a table that is empty? If you can please let me know. I made table through "make table" query and now I run the append query to the empty table but it is not putting any information in the empty table Can you append to a table that is empty?

I have created an append query. Inside that query I have one column that take a result from another query and I have about 10 columns that follow that one column by infomation from a table. I do have the query and table "join properties" at "Student-ID". I am appending to a blank table but its...

I figured it out. I ran a macro to open them both. Thanks for your help

When I try to run a wizard in any selection I can never find the two queries that I created (the delete query and append query) I only see Select queries

I have two queries. I have a delete query and an append query. Is there anyway that I have these two queries run on a switchboard.

I figured it out. It was a lot easier then I thought it was. I have to use a delete query first and then an append query. I can not use an update. It does not like it. I have over 14000 records. I kept getting an error message. Thanks for your help

I figured it out. It was a lot easier then I thought it was. Thanks

I am not sure about how to run an update query. When I set it up I get an error message or it takes along time to run

Yes it is pretty much a snapshot of the linked table. So every time the linked table is updated I want to run it with the table is not linked to see what has been added and drop. After I see those changes I want the old table to be updated with the linked table. I know what a delete query is...