Recent content by rzkl

Thank you for your response. The reason I was trying to accomplish in a query is that i do not have any experience in VBA, still trying to learn. If there is anymore direction that you can give me on this it would be great. Not sure where to put this code or how to retrieve my answer. Thank you

Hello, Not sure what I would search for on this but I have a table that has two columns, one is an item number and one is a qty. What I am trying to get is a query that will combine all the records together in one long string with a comma separating each number. see example Thanks in advance...

Hopefully this is the right place to post. Im trying to find out the amount of time between each record. A little background, I have a table full of entries. Each entry is an activity with a single timestamp and the amount of time it should take. My problem is that each entry only has one...

I never thought of it that way but I believe that will work, I will have to go down to seconds as some of the activities are measured 200 per hour. Thank you for the direction/suggestion

Im trying to calcaulate time for various activitys. I have a few tables listed below. One holds the activity and one holds how much time should be allotted to the specific activity. Generally these activities only take a few minutes or less to complete. I am having problems doing the various...

I am trying to set up the criteria in a query to query a date/time range. I have a form with two calendars on it, a start date and an end date. Our work day starts at 4:00am and goes to 3:59 am the following day. I was trying to accomplish this by the following Between...

Thanks, the code worked. It took almost 15 minutes for the query to run, Im not sure why but the query only had less then 300 records to sort through.

I have what I would have thought would be a very simple task to solve and I just can't figure it out. I have a table of inventory records. I want to do a query to limit the output to just 15 records per item. The fields in the table are ItemNumber PalletNumber This table has ten to twenty...

I have a query problem that I have had no luck solving either through books or other post on this fourm. It might be because of my lack of Access skills or just might not be possible. I have a query that looks at one field in a table to count how many records have the check box checked. It...

I am try to make an access database to create pallet tags for some package and ingredients items that we purchase. What I would like to do is after the purchaser creates a PO in our purchasing system he would enter that information (SKU and total quantity)into a table. Someone from the warehouse...

Okay thank you I will try that out and let you know Thanks

Access 2000 Access 2000

Hello, I have a database I'm designing that will be used to print pallet tags. I have two different printers that will be printing them that are located a fair distance apart. I have a table setup with product descriptions and all the information that will print on the tags, in that table I...

I have a database that I scan barcodes from pallets of product into. I have two different networked label printers on different sides of the whse. I would like to send the labels to a specific printer based on what the product that is scanned is. Is there a way that I can assign different...

That worked thank you