using data from two tables but without dependancy

[leewisener]

I have a number of tables that list customer accounts, each table represents a month, Jan, Feb, Mar, Etcc.....

I want to display data from two tables March and April on the one form to compare them.

how would I do this? I want to display all the records from table 1 and all the records from table 2 side by side.

If I run a query it will only display all data from 1 table and only the matching records from the other.

I cant figure this out.

Thanks for any help

Lee

 

[scriverb]

You should be able to create two unbound calculated controls to do this. Use the DLookUp function.

EXAMPLE:

=DLookUp("[returnfield]", "[tablename]", "[criteria_field] = monthvalue")

Now the parameters and names above will have to be modified and can be a calculated value so that the Date() function along with the Month function can be used to determine the two months that you want to see.

Post back if you need more help with this.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[scriverb]

Sorry about that I just re-read the thread and you want all of the records from two tables. The DLookup won't do that. But, you can create two subforms each with their own query as the RecordSource and display the continuous subforms in subform controls side-by-side on the same main form.

Post back if you need help with this also.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]