Hello to all,

I am writing a query that is attempting to take three fields in a table, and create a new field called "MyKey." I'm doing this using concatenation. The problem: two of these fields, Storage_Facilit y and Storage_Receipt _Number, are integer fields. The third of these fields, Receipt_Suffix, is a char field. It appears that SQL server will not allow this. I can do it in Microsoft Access, why not in SQL Server?...

I have an invoice report in Access. I have three invoices. I want to force a page break after each invoice# so I end up with three invoices, each with a header (invoice# date etc.), detail (items purchased, cost, extension etc) and a footer (totals, amount due etc.). I can't for the life of me do this after spending a morning trying to use the force page break proprty setting.

My invoice design has a report header (invoice# etc.),...