Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.

mme



145 posts

Master Geek
+1 received by user: 1

Subscriber

Topic # 26371 20-Sep-2008 11:57
Send private message

Hi

I am trying to make a simple access document that allows me to generate simple ordering reports. A list of products with a number box beside them is displayed. in the number box alows me to write how many I want to order then it should generate a list with the products that have a higher value than zero and with the numeric value beside the corosponding product

What would be the easiet way to do this in access?

Thanks

Create new topic
2483 posts

Uber Geek
+1 received by user: 4

Trusted

  Reply # 165811 20-Sep-2008 12:41
Send private message

It's pretty simple...

1. Make a relevant table
2. Make a query to find all records with your wanted order number > 0
3. Make a report of that query.

At least that's what I think you want to do, but tell us if it isn't.




Find me on Twitter!

I posted 1, 2 x 10^3 times!

mme



145 posts

Master Geek
+1 received by user: 1

Subscriber

  Reply # 165813 20-Sep-2008 12:52
Send private message

I thought I would be more complicated than that, All working now

Thanks

Create new topic

Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.