Last Check Number query problem

[sdelgado]

Part of a query is looking for the last check number in my check register table. I have tried doing it in the Totals row by 'Last', I have tried using criteria last, I have tried a formula in the field using both DLast and Last. Every time I get check numbers 100 to 300 checks back in the register. Any guesses, suggestions?????

 

[Rich]

Use DMax instead

 

[sdelgado]

How do I use DMax?

Ok, my query is using two tables. tblBatchExport and tblCheckReg
BatchNum, BatchRunDate come from the first, CheckNo comes from the last.

I want to make a single row table with these three pieces of data. (the table they make is used by Crystal Enterprise to run a series of reports)

If I use the 'totals' button and do group by for the batchnum and batchrundate it works fine but if I use Last or Max the checkno (properties is a number not a text) I get odd results.

I tried using the dmax as a formula field but got a type mismatch. I tried using the 'totals' as described above with DMax as a criteria and still got the type mismatch.

I hope I've given you enough to go on, I appreciate your help.

 

[Rich]

What's the link between the two?

 

[sdelgado]

more on Last Check Number query problem

tblBatchExport and tblCheckRegister link up by batch number, except that in this scenario the current batch of check hasn't been printed yet so it would be the last check number of the last batch or the last check number in the check register