UpDate Form from query

S

silvex

Hi. Can someone help me please.
I'm new in Access
I copied the Quarterly Orders By Products query from the Adamastor example.
Now, I want to see this data by Month. So, what i did was to substitute the
expression "Qtr " & DatePart("q";[OrderDate];1;0) and wrote "Mth" & DatePart
("m";[OrderDate];1;0). The query works OK.
Then I create a Form based on this query, and it worked OK too.
The problem is: When I update the data with a new month, for example with
dates in October - the query updates well, but in the form thus not appears
the new month. Is there any way of update also the form?
Thanks for your help
 
S

silvex

well i think i solved it:
I put new fields in the form corresponding to the months that have'nt yet
been filled.
But now i have another problem: In that new fields appears (#Name?) and in
the Total Fields appears (#Error) unless all the Months are fullfilled.
Is there a way to solve this
Thanks again

"silvex" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display "DatePart("M",[OrderDate])" expression as text 4
Cross Tab Query 4
Using a form to input update query criteria 2
Crate Table Query - Closest to the 15th day..... 0
Return all dates for 'next month' irrespective of year or day 4
Update Table Value Based Upon Form Entry 2
Rounding decimal values in forms and reports 2
Use a Qry as a filter in a form 9

Top