Re: Can I create a field in a table containing a formula? ...ktlooney wrote: ... > I have two numeric fields and would like to create a field in the ... you do this in a query and then use the query every place where you need ...Prev by Date: ... (microsoft.public.access.tablesdbdesign)
Re: counting records ... > I have a table with one numeric fields.... > i want to add a record number field in a query... Hi Pierre,...Prev by Date: ... (microsoft.public.access.queries)
COMPARE FIELDS QUERY ... I need a query that searches 2 fields in 2 tables. ... There are 2 numeric fields in each of the 2 tables containing numbers such ...Simon Gare...Prev by Date: ... (microsoft.public.access.adp.sqlserver)
Re: Exporting Data as text file ... To have the spaces replaced with zeroes, write a query that uses the Format ... function on the numeric fields (not the Format property),... Doug Steele, Microsoft Access MVP... (microsoft.public.access.externaldata)
Re: Export problems ... Create a query and use the Format function in the query to convert the ...numeric fields to strings. ... Doug Steele, Microsoft Access MVP... (microsoft.public.access.reports)
