Search results

Something like this: SELECT date, Sum(amount) AS TotalAmount FROM tablename GROUP BY date HTH

Make sure the field types for the joined fields are the same.

It's possible their local PC system date time format is causing this. Check the Control Panel and Regional settings. HTH

JJT, I think your best alternative would be my suggestion on your original post of 9-17. If your not sure how I can give more detail.

If you want to execute a series of queries use a macro. That should work if I'm understanding you correctly.

Go into the properties of your form and change 'Data Entry' Yes. Create a macro to run the maximize command and assign it to the 'on open' event of form. HTH

Try doing this: Copy the structure of current table into a new table and make the case number the primary key. Append the data from old to new. This will keep first record and drop all dups. [This message has been edited by arickards (edited 09-20-2001).]

Hi Tom, Got your email. Try this on the on open event of the form: 'Function Macro1() On Error GoTo Macro1_Err DoCmd.RunCommand acCmdRecordsGoToNew Macro1_Exit: Exit Function Macro1_Err: MsgBox Error$ Resume Macro1_Exit End Function HTH, ASH~

In the form properties make the form data entry.

Could I get a copy too in A2K? Thanks.

Insert the subforms into your main form. In the properties of the subform use the link master and link child property and type in the field name you want to link by. HTH

I have a large form and currerntly with all the subforms and other info it is slow. What I would like to do is have buttons that will only load and dislay the related info of the current form. TIA ASH~

Sure is. Use the open query in the first row. In the second use the msgbox. HTH ASH~

Try this. Create a query and add both tables select the fields etc.. Create an inner join, assuming you have a field in both tables that link the records. Then on the control source of the form use the query. HTH ASH~

Try this. Create a query and add both tables select the fields etc.. Create an inner join, assuming you have a field in both tables that link the records. Then on the control source of the form use the query. HTH ASH~

Its possible you could use a macro to run an append query. Assign the on click of the command button to the macro. [This message has been edited by arickards (edited 10-04-2000).]

Create a query as the control for the form. Then see my response to Dale Cleeve, Combo Boxes and Fields. I believe your needs are analogous.

Use an unbound combo text box on the form. In your query insert this for the criteria [Forms]![FormName]![Modeltxt]. For the row source, link it to the table and column that contains your models. If that does not work simply make a seperate table that contains individual models and make that...

Create a query with all your tables. The tables will need a uniqe key to link. Create the form and have the query as the control source.

Use a crosstab query to accomplish this. Use the GroupBy and Sum features.