Search results

Great to hear from you Brian. Was getting worried that you weren't coming back.

Well congratulations ... or commiserations, depending on what you were aiming for.

I can't replicate your problem but I've added the average into your sample query and it works fine for me. See attached.

How have you set Mark up? i.e. what data type, decimal places, precision etc. Can you post a cut down version of your database with dummy data to show the problem?

You could add this function then use it in your query: Public Function minDate(d1 As Date, d2 As Date, d3 As Date, d4 As Date) As Date minDate = d1 If d2 < minDate Then minDate = d2 If d3 < minDate Then minDate = d3 If d4 < minDate Then minDate = d4 End Function But I agree...

Go into the design view of of the query again. Add a new column as follows: Field> AVRG: [Mark] Table> Your table Total> Avg Crosstab> Row Heading Run your query. The avrg will probably display on the left of the other values but you can drag it to the right.

Make sure the group section is grouped on RequestDate. Move the RequestDate textbox to the group header. All the other detail stays in the detail. Add the group footer and change the Force New Page property of the group footer to After Section.

Just add a round close bracket on the end ")"

See attached to get you started. Essentially create a table of all the month ends then do a Cartesian product query which will produce all possible rows and filter only on rows where monthend is between the two given dates. See qryOutput. By a similar principle I can't see why you can't...

Glad to hear you figured it out.

Ah, so you want to summarise the data and not show the details? So you should google aggregate queries. They are dead easy to do.

If you want to display on screen then use a form. If you want to output the use a report. Both tools are designed to group and total as you request.

Do some research/tests on passthrough queries. If you run a query using the Access database engine then the engine pulls all the data from the source tables over the network and then processes the query locally. With a passthrough query, the query is passed to the server and the server...

Go into table design view. Then click on a field. You should see all the attributes for that field including "Caption".

Yes I'd shorten (or create my own) headers. Long field names aren't at all practical. Furthermore, you'll have all sorts of undesirable characters to contend with e.g space. Field names should not have spaces etc. But you can use the fields Caption attribute to store the long name. This will...

I would think you could do something like this: ALTER TABLE b ADD CONSTRAINT is_in_c CHECK (EXISTS (SELECT * FROM a WHERE b.somevalue = a.somevalue)); So the above check that a value exists in the lookup. For cascades and deletes I think you might be...

I might be wrong but the way I read it is the OP wants to implement referential integrity i.e. mandatory participation and the likes.

Remove the brackets and the expressions will run fine e.g. FoxTest2 True, TrueYou only need brackets if you are using the CALL statement. The ? in the immediate window is asking a question i.e. tell me what the result of the expression is. So when you run ?FoxTest1, the function will print the...

Look at the table called tblTherapists. There are are three fields. The second and third fields are the first name and surname respectively. The first field is the TherapistID field and is the primary key for this table. It is used as the identifier for records in this table. We in the...

Take a good look at the example I gave. Look at the two tables and the fields in them. Look at the relationship view.