Recent content by marthacasting

Thank you. I'm not sure what you mean by an append query . . .

Why is it that when trying to sort data in queries, some of the columns have a special icon next to the field name that opens a dropdown list of all the different answers in the column, and you can put checkmarks next to those you want. And other columns allow you to sort either A to Z or Z to...

Thank you for your prompt and helpful responses! I will try these approaches! It's just confusing to me why, out of the blue, this would happen when I have not made any changes over the last couple of weeks (not to mention years) in what I am doing! I am going to check it out!

Thank you. It does seem like importing would be the trigger. And I do use Excel; however I am using the same (Excel) template that I've been using for a couple of years (without incident), so I'm not sure what has changed. And does it seem disproportionate to receive well over 900 records for...

Why would that happen?

In Access 2007, I have a table with just shy of 20,000 records. In the last few days, suddenly I have been having over 900 blank records appear at the top! I delete them all, back-up, and then the next day the same thing happens again. I do import a small number (maybe 20 average) a few days a...

I simply use the Query Wizard >Duplicates Query function and choose state, first name, last name as the fields that might have duplicate information. (And then I bring over other fields for further information.)

Thank you so much for your prompt response! I am sorry to say that this is over my head though! With appreciation . . .

I have about 20K names in my DB and I want to search for duplicates. If I use first name and last name to search for duplicates, it does not pick up if the first name is entered once as Pat and a second time as Patricia. Is there something I can enter in the first name field to recognize the...

Phew! Thank you!

Thank you all! So this is what I tried and am hoping will work! I created Report A and Report B Then I went to Report Design to create a new report: in design view, I simply dragged Report A and Report B from the navigation pane into the new report. Voila (??!!) One report that holds the 2...

Thank you for your prompt response. Actually, I don't think I do want to use a subreport. I would like the top half of the report page to have a brief, at-a-glance format for the employees in tabular view. (Name, Phone, Email, etc.) Below that, I would like to have a "justified" report that...

I would like to simply append or embed one report to/into another. They don't need to be bound or have any connections. I had thought maybe I could use the "Insert Below" function (in the Arrange view) but they are greyed out. Any ideas? Thank you!!

Simple as that! Thanks so much for your kind and prompt help! Now what should I do with the "bad" query? Can I delete it with no impact? :)

Thank you. And then what do I do?!