Search results

That makes sense, yet I am unsure about the update event as I import this data into a table. Can I change to negative at that point, or are you referring to once its in the query. Where is this after update event, i am only familiar with this in a form?

At the moment I am just creating a new field name and multiplying by -1 in the query. Yes the numbers will all always be negative. I think the best thing for me to do is just make them negative in the table and as data is appended daily it will also become negative. This would just cut out a...

I realize that, I dont feel I was being uptight, just wanted him to know I was confused. I was open to any and all help, we were just getting onthe same page. He was helpful w/ me and we were making references to another thread you may not of seen. Its perceptions, dont forget your reading text...

Do you know if its possible to have one form automate multiple criteria. Like have it do todays data and then also another fields criteria? Is it possible do something similar w/ a group by total??

Very cool, thanks for the help

Yes that makes sense, but when you say form Im confued, im getting my input from the table thats being appended to daily, Is that what your saying. Its just the fact that I create new query everyday, so your saying use the same query, set Open events for the criteria and then just save the...

Thats exactly what im doing. The table is appended to daily and I use criteria to query what I need for daily processing.

I asked a question about more automation and making numbers negative and you interpret that it may be flawed, I may not be an expert but I dont understand that. Its actually pretty reliable and quick and easy functioning I just want to improve speed and automation. I am def open to any...

The data comes from a computer simulation and spits out raw data involving text fields and a few number fields. Then the object is to run a query and draw out the "days" data (todays date). There are relationships built between the daily data and other data lookups to attempt to answer your...

What way could I make the table field formated as negative numbers so that everday they come in and are negative?

I know its possible to have Access run a query, but is there any way to have it create and run the query for you? I have the same number of fields and data types coming in daily and I'd like to automate it to that point to make it easier? The process is simple and involved dragging moving the...

Currently in order to change my field from a positive number to a negative number I have to change the name of the field and multiply the old name by -1. There has to be a quicker, easier, more efficient way to do this, Anyone? Thanks Mike

That worked great, Thanks alot. I def should of thought of that. Take care, thanks makin it convenient.

I import about 9000 lines of data into Access and that consists of many lines of initials. One persons initial could include hundreds of rows and then the initial changes to another person. I would like to lookup to another table that has the persons full name. Such as many rows of AFu...

Does anyone know if its possible to use a left function to change the entire field in a query. I have a dates that come in as Mar-09/fwd and I would like only to capture the "Mar-09" portion. I just dont know where I would put the function to make it work and also how to specify the field or...

Thanks for the reply. Thats a good suggestion and where I have been going with it. I created a report and it looks good. I had trouble opening your link to look at your suggested example. When I build my reports I really want it to be appealing. So I colored it in changed some formattig...

I have an issue with my numbers in a crosstab query. I have my numbers formatted as currency with 0 decimal places but when the crosstab is created the formatting is lost. When I use the property sheet to change it back it is ineffective. I have written different expressions Such as a CCur...