Re: cycle thru list adding date
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
On Thu, 28 Feb 2008 11:38:01 -0800, JohnE <JohnE@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Dale, thanks for the info. Unfortunately, it is the field in the database
table that needs to have the export date filled in. All of the records
showing in the report (or the query behind the report) will have the date
field filled in with the exporting date.
Why?
Are you assuming that you must have the date stored in a table field to export
it? You don't; you can export a query with Date() in a calculated field, just
as easily as the table.
If you want to store today's date in the table, you'll need to do it in two
steps - an Update query updating the records that are to be exported, setting
the field to Date(); followed by a separate operation to export the updated
table.
Of course you'll have complexities if the same record gets exported multiple
times.
--
John W. Vinson [MVP]
.
Relevant Pages
- Re: Populating a list -- table structure?
... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
(microsoft.public.access.forms) - Re: Access 07 - Confused while trying to create a report
... I have a general query that feeds from a table (in that table there's ... Then if you use the report wizard to build a report based on each joining query, Access will spot the relationship and offer you exactly what you want with almost no work on your part. ... The "uniqueID" needn't be shown in the subreports. ... I have an invoicing report which shows a few details of the current customer, and has a subreport showing their unpaid invoices, another showing goods & services supplied, another showing "hourly" work done and a fourth showing payments received, all totalled up into a "sum outstanding" via controls in the subreport footers. ...
(microsoft.public.access.reports) - Re: Fields in Label dont give correct information
... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
(microsoft.public.access.reports) - Re: Tips on domain aggregate replacements
... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
(microsoft.public.access.modulesdaovba) - Re: using a form with combo box to input criteria
... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
(microsoft.public.access.forms) |
|
