Is your intention just to display your two fields at the time of creating a report or query? If so, in your Select query you can assign these values. Where do you get the "MyCompany" info from? Is this another table or within the same table your Select query is based upon?
I wanted to give you an example of syntax to refer to where you are getting your MyCompany from. If it is an existing piece of information contained in the table(s) used in your Select query that would be one syntax. If it is contained on a table not used, that would be different syntax.
The data value that I wish to populate in the FieldName1 column is simply an arbitrary data value that I need to populate in every record of the select query result set in that particular field. It is not stored in any table or database.
When the select query is run, I would like every record to contain the data value "MyCompany" in the FieldName1 column.
Now on to my second problem......I have another 'contrived' column 'Data_Period' for which I want to populate the date of the last day of the prior month. i.e. for a report running in May, 2013, I would need the date that shows up in the "Data_Period" column to be 2013-04.....