Good Evening from New Zealand. I have an accident table with amongst other fields IncidDate, IncidStatus and IncidId. I have created a statusT from a query and a crosstab query from the StatusT now I want to print this Xquery as below
2101 2102 2103............2311 2312 "status 1" 3 5 23 2 "status 2" 23 4 etc I can do this as an one off but using a parameter to run this annually my report heading need to be changed manually to 2201 2202.....2411 2412. Is there a way to do this in access. Many thanks for this and previous answers to my problems
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
Visitor Forum.