Search results

In what way is it not working? Do you get any specific error messages, and/or does the data append incorrectly?

So you want to filter the results in the form to show the just one date?

I'm not a "Gent", but I assume it's OK if I respond? There was a similar question posted recently, regarding upcoming birthdays: http://www.access-programmers.co.uk/forums/showthread.php?t=181136 And I had a somewhat similar question a few months ago where I wanted to generate a list of...

I will tell you how I would do it: Make a new query, and add both tables. Add to the query all the fields from the parent table you want in the result. Add to the query the field you want to count. Turn on the "group" button (the Sigma symbol), from the toolbar. In the field that you...

THIS splits data into multiple fields - not exactly what you wanted, but still... LOTS of tips on normalisation... THIS looks like exactly what you're trying to do... And while I'm kicking myself for not being more on the ball, have you already investigated the functionality of the import...

Oh I'm sure it's possible! Access will do a back-flip and hand you a cappuccino if you know how to ask properly. Splitting data and bunging it into separate fields or records is something Access can do half-asleep with one hand tied behind its back - I just don't know how to do it lol. Most of...

Right, k. Good luck!

Being the Word maven and Access n00b I am, if I understand you correctly, what I'd do is use Word to normalise the data with find and replace or TextToTable, then paste, import or upload the data into Access. Is that what you mean? You want to turn the one record with all its "many" data in...

When you exit MSWord, are you asked to save changes to the Normal.dot or Universal Template (or similar)?

I'm using a much older version of Access: 2000. Mine looked like this: My first calculated field was: Total: Sum([Table1]![Monthly hours]) My second was: Total Plus: ([Total]*13) I had grouping turned on, as "Expression". Don't know if newer versions of Access even work like that.

Can't you just make a new calculated field and calculate on it? I did it to try - is there a reason why that wouldn't work for you?

A couple of questions: 1. Is the number you're multiplying by static, or variable? 2. What are you doing with the result? Will you be viewing it in a form or a report, etc?

You're talking about a parameter query and the string I use in all my queries is a little different, and it runs from the first typed date to the second, not excluding the first and last as you are concerned about: Between [Type the start date] And [type the end date] My date format is short...

It totally, totally worked and I so appreciate your help!!

Unfortunately, I can't open your example because I'm using Office 2000 (I know... I use what I'm given). But I will try to follow your instructions and see what happens. Thanks so much for your help!

Correct. When I run the query as a plain select query, I get (using the example I checked on) two returns for the record "ABACO" used as an example in the preceding screencap, one for Lukah and one for Nat. As you can see from the screencap, Zona has also contacted that record.

I just looked, to double-check if the query was working. The "T Visit Info" table records every contact with customers. When I view my data in the data entry form or in the parent table view, all the related child records are visible.

Thank you very much for thinking about my problem and replying with suggestions. OK, just to make sure we understand each other: the table that contains the data I want to query on is in the child table, “T Visit Info”, not the parent table, “T CONTACTS”. Also, the CID field is the CustomerID...

Some grouped queries, and some queries based on other queries, don't allow editing. Is this true of your query?

Thanks very much for the reply! I guess my attachment wasn't clear enough, sorry about that. I already know how to do lists of records in the parent table with no associated child records, but what I need to do is to show a list of parent records that haven't been contacted by a certain...