Search results for query: *

Good afternoon all. I need to set up something for recurring tasks. I have a start date in normal date format and a task interval in number of weeks. I'm hoping that there is an expression that I can use in a query that will flag the tasks that need to be done this week based on the above...

Good morning all. I have a query that is doing a comparison between two tables. One column has data like 37820-P06-C52. There are literally thousands of possibilites because everything other than the 37820 varies. Not all variations are in the table though, only a few hundred at a time. The...

Good morning. I have some infomation in a table that looks like this: E8FZ-AA. Some of the data has been entered in incorrectly and has a number in the last series of characters like E8FZ-A1A. Is there an easy way I can strip the numbers out of the part of the information after the -? Thanks...

Good morning. I have a table with four columns, ID, PartNunmber, Quantity and Location. When I run a query on "Location", one of the records shows up twice. If I total the PartNumber column, that part number shows 2 instead of 1. Where should I look? Thanks in advance. Ethan

Good morning all. I have a form to enter parts into inventory. The first box is the part number. The second is "Quantity Good" with a default value of 1. The third is "Quantity Broken" with a default of 0. I am trying to get the default to be linked to the "Quantity...

Good evening all. I hope this can be done easily. I have to create an Access table from an Excel file. The excel file has multiple worksheets. Each worksheet is set up to print nicely so instead of a single 400 line column it will have 5 60 line columns. I have been cutting and pasting each...

Good afternoon all. I have field that has information like this: 2 4 5 2 cn * 1 etc. formatted as text. As part of a query, I need to do the following: The numbers must be numbers, hopefully as currency. The "cn" and any other text must be ignored EXCEPT the "*" which...

Good afternoon all. I am using a combo box to enter data into an inventory table. Since I sometimes have to use the same part number twice with different descriptions, I have to use the ID column as the important data. The inventory table has only the ID number and the quantity. The problem...