I want my calculated field in a query to be right-
justified, but when I go into "Properties" and "Format"
the drop-down list is empty. Fields from tables have the
usual selection available. How do I get my query to treat
calculated fields as a number?
Re: Else If Statements ... are saying I would have first take the select query with the calculated field... in it and make it into a make table query and then do another select query. ... Within the origional table there is a post code field....postcode down to only show the first part of the postcode i.e. the alpha ... (microsoft.public.access.queries)
Re: Date Format problem in parameter query ... it sounds like Access is confused about the data type of the field. ... Are you applying this on a calculated field?... In query design view, choose Parameters on the Query menu. ... > its Format property...nothing fancy ... (microsoft.public.access.queries)
RE: Passing variables to Function ... Ok here is the calculated field from my query and my primary function. ... add previous cycle totals if they exist. ... be called from the qryReagent1 query.... (microsoft.public.access.modulesdaovba)
Re: Else If Statements ... I started with a table with about 8 columns in it and then pulled a query... Within the origional table there is a post code field....postcode down to only show the first part of the postcode i.e. the alpha ... What I need to do then is to put another calculated field into the ... (microsoft.public.access.queries)
Re: Exporting Dates from Access to Text Files ...calculated field, use the Format function to explicitly define how the date ... column formatted in my query as dd-mmm-yy, the date shows ok in the query ...window, and in the export window, but in the final fixed length text file, ... Is there a way I can get this date format to export to a text file in the ... (microsoft.public.access.externaldata)
