I note that in this Query where it Partitions the Currency it shows as 0: 49 the 50: 99 Etc. Is there a way to have it displayed as Currency values? I was playing with this and trying to figure out if it can be then how? so that it displays $0: $49 etc
Allan McConnellOP
@Reply 4 years ago
Must add for anyone else reading this that this relates to Access Expert 18 Lesson
Scott Axton
@Reply 4 years ago
Allan -
I've been playing around with it this morning. Searched Google as well. It doesn't appear from everything I've found that you can change / format the column heads when you use the Partition() function.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 18.
