Recent content by Accessosaurusrex

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

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

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!

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

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

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

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

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

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

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

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

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

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

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

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