Jump to content

Putting several Records into One Record

shedproductions
 Share

This topic is 6850 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
shedproductions Newbie

shedproductions

Posted
  • Newbies
Posted (edited)

Version 5

Having trouble with the logic.

Have a POS System and want to take the Sales information (Mulitiple Records) and transfer them

into another database (Close out). Each record in Close Out represents a Day. Thus I want to take the

sales records from sales (mulitple transactions"Records" and transfer them into one record. Have a fixed number of fields in the Closeout file to drop them into. The logic gets harry for me when it has to take the data from 5 or 6 fields and drop them into First entry fields.

If they have something in them, drop to the next fields down.

This may be an IF statement or a Case statement.

Just having trouble figuring the best way.

Help!

Edited by Guest

This topic is 6850 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept