Search results

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...

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...

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...

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...

Hello, I have a problem with a database. It was created in Access 2000 on my work PC. I emailed it to my home PC, I can open it no problem but when I go to run one of the queries that uses the function "Left" in it I get a popup saying Undefined function 'Left' in Expression. Any Ideas...