one record table - Append? problem

  • Thread starter Thread starter Tcs
  • Start date Start date
T

Tcs

I have a table in which I believe I only need one record. It is a table of
aging periods (e.g., current, 30days, 60days and 90days). I want to get the
current input from the user and then calc the prior periods in VB. I'm trying
to use an Append query to write the one record, after getting the current period
year and month from the user. Access isn't letting me.

What am I doing wrong? How SHOULD I do this?

Acc = 2000
OS = XP

Thanks in advance...
 
You should use an Update query rather than an Append query, but beyond that,
you need to be a little more specific about what "Access isn't letting me"
means.....

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress
 
I have a table in which I believe I only need one record. It is a table of
aging periods (e.g., current, 30days, 60days and 90days).
Click to expand...

Eh? That looks like four records to me (with two fields, perhaps).
I want to get the
current input from the user and then calc the prior periods in VB. I'm trying
to use an Append query to write the one record, after getting the current period
year and month from the user. Access isn't letting me.

What am I doing wrong? How SHOULD I do this?
Click to expand...

It sounds like you're using a one-record table as a scratchpad to hold
data on a temporary basis. Could you explain what you are trying to
*accomplish*? I suspect that this table should not exist at all.
 
I don't want multiple records. And I got it to work. At first, I was assuming
it had to be an Append query because I've conditioned myself to always flush a
temp table. But since I only have to update the one and only record, I
shouldn't have to flush it. And it now works.

I run a query that has two parameters, which are the current month and year.
Then I have VB code that computes the remaining months and years. It's just
what I want and it works just fine.

Thanks a lot.
 
Back
Top