query insert data problem

[Guest]

i mail two days about a problem that i had with three fields in the same
query line
my table as the fields: date, product code, quantity
my query as you help me is
date, product code, quantity(date-1),quantity(date),quantity(date+1)
for this i have done 3 query with the diferent date catches.
now the problems are:
1- can't insert data in them.
2- if their is no data on "date+1" i have 0 results.

thank u
if you think in a better way to do this, im open to new ideas

 

[Jeff Boyce]

Roy

First, consider changing the name of your field you've called "date". This
is a "reserved word" in Access, and you will only confuse Access and
yourself by naming a field with the same word.

I didn't see your earlier email, so I don't understand -- if you are trying
to insert data, what data are you trying to insert, where, and why?

 

[Guest]

my table as the fields: Main date, product code, quantity
i want a query with the result to be:
Main date, product code, quantity(date-1),quantity(date),quantity(date+1) in
the same line.
and i wont to be able to change the "quantity" of the columns +
i wont the query to work if 1 of the days is empty.

thank you

 

[Jeff Boyce]

Roy

I'm still not following your question too well.

Why do you want/need to change the quantity -- how does this help you
satisfy a business need?

If your query is reporting what is actually recorded for a given date, for
the day before, and the day after, why would you need to change the quantity
at all?

Please provide a copy of the SQL statement(s) you are using.