I suppose, but I don't use arrays much. The method I've seen most commonly for the loop is using LBound and UBound, which automatically give you the upper and lower values of the array.
Who is John Galt?
Windows XP 
Access 2007
I suppose, but I don't use arrays much. The method I've seen most commonly for the loop is using LBound and UBound, which automatically give you the upper and lower values of the array.
Expert
Windows XP Access 2000
That would make more sense to use LBound and UBound as opposed to having to just guess how many will be in the array. I'll google that to determine how to do it. Thanks again.
Who is John Galt?
Windows XP Access 2007
No problem. I'd still consider changing to SQL; that method strikes me as unnecessarily complicated.
Expert
Windows XP Access 2000
I am beginning to agree with you. The more I am understanding the process of what needs to be done, it seems like the way that is set up is more steps than need to be.
Running Sum
Re-Running a report
Behind the scenes
Posting Permissions
Reply With Quote