Can you use IF formulas?

[jbeling]

I am trying to make a table or a query that auto fills in if another table or query has met a certian criteria. Basically here is my set up:

Query 1: has a check mark in a given cell, or it says YES.

Table/query 2: I want a given cell to say Yes, or auto populate a checkmark, because there is at least 1 check mark, or YES, in a cell in table 1.

I want to do this because i have about 20 queries that I need to check if there is any data in them daily, which changes daily. I hate checking every one and then jotting down which ones I checked. They are basically just contact info that i then mail merge into word. So if i had a master table that had a check mark next to each query that had any data at all in it, I could just print that table/query and know which ones to mail merge.

 

[Premy]

How about doing an update query that updates the check mark field to True or "yes" and put a Not Null in the criteria line beneath the field that should have data in it.

HTH

 

[jbeling]

How about doing an update query that updates the check mark field to True or "yes" and put a Not Null in the criteria line beneath the field that should have data in it.

HTH

How do I do that? Should I make a new table, or query? I guess I just don't know the steps involved in doing that. Thanks!

 

[jbeling]

I may be confusing you. I have about 15 querys that I use as the source of a mailing database. The different querys have different criteria that make them apart of that query, and the querys update daily. For each query i have a word document that is different. Instead of having to open all 15 to find out if there is any data in there, I would like to just be able to open one query, or table, that has the query name in one column and a yes or a no in another. Yes, there is data in there, or NO there is not.

Is this possible?

 

[Premy]

Well I'm sure it's possible, for one. If u just want to know if there's any data at all in a given query u could maybe create a form with 15 textboxes. Connect each to a query with a Dlookup. For example, txtBox1 source =DLookup("Field1;"Query1"), txtBox2 source =DLookup("Field2;"Query2"), and so on.

U might then create a button "btnPrint" and put this code behind:

Private Sub btnPrint_Click()
If Not IsNull(Me.txtBox1) Then ... 'Put the code for your mailmerge here
If Not IsNull(Me.txtBox2) Then ... 'Put the code for your mailmerge here
...
If Not IsNull(Me.txtBox15) Then ... 'Put the code for your mailmerge here
End Sub

So all u have to do in the end is to click the button and have all your queries WITH data, merge into word, one after the other.

HTH

P.S. Search AWF for some powerful mail/word merge routines, in case u haven't already got one.