Append query problem.

[nicola1]

Hi all,

I have a problem which i hope someone may be able to help me with.

Basically my users currently look at their sales statistics by looking at a query based on the table where they enter the records from.

As the sales figures change, the values in the table change, because the table that they actually see, is run off a query which just average the sales to date....confusing i know.

Basically my users have asked me for an append query, they want to be able to click on a button and then append the data which they can currently see into a table, so for example if they clicked the button (appended the query) last week and then today, they can see the difference, whether good or bad over time.

My problem is that i am unsure how to record the date that the users click on the button on each of the records they append, ie so when i do my report they will be separated by weeks and the user can see the clear difference.

I would appreciate any help, or pointers in the right direction.

 

[Pat Hartman]

You will need to add an additional column to the new table to hold the date/time. In your append query, select the new column in the append to cell and in the field cell of the QBE grid, put:

CurDate:Now()

 

[nicola1]

Hi Pat,

It works perfectly...thank you very much for your help again! i wouldnt have known where to start.

 

[wkalo]

Hi There

I Have Implemeted Waht You requested But In Adifferent Way Then Suggested.
I have Created The Sales Report By Using The Pivot Table As It Organises Sales By Date And The Client Would Compare Easily Between Different Week Month Or Even Daily Sales
Also From The SAme Report You Could Choose To View AS Graph