Search results

  1. A

    Adding multiple data to one field

    I agree with the assessment about not storing multiple bits of data in a single field. I will go through the audit data today to see how that would impact this issue. Let me try to clarify the final result a bit and see if that helps you fine tune which options I should look in to. I use one...
  2. A

    Adding multiple data to one field

    I would like to be able to have the date written in to a field when another field is updated. Pretty simple, however, there are circumstances that this field could be updated as many as 6 times. I will have to build a query that will search this field for specific dates so I can count...
  3. A

    Updating records based on form data

    My apologies for the length of time in replying, however it worked beautifully and thanks for your time. I thought I had posted earlier but was cleaning out my e-mail and noticed that I had not. Thanks again!
  4. A

    Updating records based on form data

    The second scenario is accurate. "There may be other records in the underlying table where NS, RX and RE are False and ClrDate is Null, but you don't want to update those records, just the ones in your Form's current Recordset." There are thousands of records that may have the NS, RX and RE as...
  5. A

    Updating records based on form data

    I am looking how to build the code so that if a form you have open has a value of 0 in three different fields, I can press an update button at the bottom of the form and it will place the current date in another field on each record. To explain better (hopefully), I have three check boxes on a...
  6. A

    Vertical Reporting

    My apologies for being confusing. I have everything working through use of pivot tables in Access 2007. I modified the data so the pivot table would work for it and then simply did a query to clear a table, append to the table and then create a report from the appended table. That seems...
  7. A

    Vertical Reporting

    Well surprise. As soon as I got it running that way, one of the end users wanted to change it so the values are separate for other functions. So is there any way to have a 4 field table lay out the data in a vertical column like a cross tab query, or is there some way to merge a pair of cross...
  8. A

    Vertical Reporting

    Well that actually worked for me for now. I think it will be fine right up until someone gets a great idea to start having to manipulate those numbers individually. For the moment that was a perfect solution. I simply did a make table query to export the values needed and then did an...
  9. A

    Vertical Reporting

    I have read through the other posts and am not sure which way to go. I have a table that has 4 fields in it. What I want for a result is to put this in a column format. The four columns are a date, a name and then two numerical field values qty and reject. This data covers a lengthy period...
  10. A

    Multiple Criteria Query

    I changed them over to number fields and removed the quotations so now it looks like this: WHERE (((Bcone.Job)=[Enter Job]) AND ((Bcone.Re)=-1)) OR (((Bcone.RX)=-1)) OR (((Bcone.NS)=-1)) However it still does not give the return I am hoping to achieve. I need to separate the query into two...
  11. A

    Multiple Criteria Query

    I have a table with 14 fields. I am looking to pull up records based first on a user input to match one field and then all records that meet a criteria of three other potential fields. My code is as follows: SELECT Bcone.Job, Bcone.ID, Bcone.Customer, Bcone.Desc, Bcone.Code, Bcone.Element...
  12. A

    Coversion of Text to a number

    To BBQ Kittens, it was very close, I simply removed the quotations around the field brackets and used the & symbol in lieu of the + symbol and it worked. Thanks you! To Alansidman, the sort order is done with the numerical value in the middle of the sort. These fields describe components and...
  13. A

    Coversion of Text to a number

    I have a database that has been working fine but one field was listed as text. As it turns out the field is used strictly for numbers and we would like the reports generated to be grouped by a sequential list of numbering from that field. I simply converted the field to a number type rather...
  14. A

    Question Copy external files to the database

    I have gone through the forums and have found some helpful answers but I lack the skill to close the loop. My database is updated several times a day and receives its data from a CSV or TXT file. My problem is that I need to clear the text from the file when it is updated in the database...
  15. A

    Duplicate Values

    Thank you very much for the advice. I had thought of that but to be honest was just being lazy as there are about 14 reports off this table and I will need to go change them all in order to do that. Anyway, you are correct. That is the right way to go. Getting my report editing fingers...
  16. A

    Duplicate Values

    I have a handheld barcode scanner which sends data to a CSV file that is then imported to an Access 2003 database. From the import table, the data is appended to a user table with primary keys set to prevent duplicate data. I use 5 fields to make a primary key. The problem is that we update...
  17. A

    Update Query from Form

    I will attempt to describe this well but may struggle a bit. I have a table for a 2003 Access dbase that originally had 7 fields. I have added an 8th field for easier categorization. Let’s call field 1 job and field 2 dept and field 8 actions. I have built a query to have the user input...
  18. A

    Best way to perform math functions

    I would like to know how best to address performing basic math functions from queries from a single table. I have one table that I run a query to get a certain group of data from. I am attempting to get a percentage so the way I do it is count how many records I have with one criteria and then...
  19. A

    Check Box and Date

    Perfect! Had to play with it a smidge but is great! Thank you very much!
  20. A

    Check Box and Date

    Here is what I want to happen: Uncheck a check box that changes a value from -1 to -0 in a field. When that happens, I want a (now) date/time filled in to a field of that record. I am willing to use two clicks to make this happen if needed as the user will be working off a form, and I can...
Back
Top Bottom