Big X
Last Activity: Sep 5 '08, 01:37 AM
Joined: Apr 7 '08
Location:
-
at the moment I got it working by first creating a new table with the null values then running another query to do the sorting. Would like to do it in one query if possible but if not no worries. -
The flag is working. But in the same query can I then go
order by BarcodeNull, State
It does not seem to work and asks me for a value for barcodenull. I guess its trying to order by a field that hasn't been created yet.Leave a comment:
-
sort null then by
Hello is there a way to sort a column by null or not null then by a second item.
Basically I have data for bar coding letters and 92% of the records have that data. So I want to to sort it by the bar codes then by state. Problem being barcode is a number and it does not work.sorting it that way. The null not null is the only way and I really just want to know if there is a SQL query that can do that because it will make my job a lot easie... -
I'm not sure what your access experience is. But try creating a query
for that field with the following criteria
put into Criteria one
put into or like *one
put into or like one*
That should produce them all in a query then you should be able to select them all and hit delete.Leave a comment:
-
There is data cleansing software called winpure if you want to wack that into google you can download a demo and see how it goes. It doesn't take to long to go through its tutorials and work out how to bring up duplicates. Its is also very good for removing bad data like numbers on the end of a company name etc. Let me know how you go with it.Leave a comment:
-
That option does not seem to work with the field name. I just got it from Microsoft help updating table with a table. In the end it isn't a big deal. The way Ive been doing the jobs at the moment is I run certain query to find bad addresses then mark them in a column. I then run a query to retrieve all bad addresses and create a CSV for the customer which they update and send back to me. I then run a query on the original table to produce good addresses...Leave a comment:
-
Not really I just wanted an easy way to update in access. From what Ive been reading I can do a query in access with the old data in design view then put in the update attribute boxes [FIELDNAME].[TABLENAME] . That is an easy enough option I guess but its a bit of a pain if there a lot of fields and no drag and drop option.Leave a comment:
-
Update In Access
Hi,
When I receive data for mail outs I separate good addresses records from bad and send the bad ones back to the customer who then updates them and sends them back to me. What I want to be able to do is when I receive the records back is to update them into the table I have over writing the old records(bad records) with the new ones. Using the design query window I have brought the new record table in and select update query option.... -
Access Auto Formatting (of Query SQL)
Hello,
In access when I write my sql statement to produce work when I reload a saved file it seems that access changes everything. i.e I will write code
line 1
line 2
line 3
When I reload access sometimes it adds code that may be necessary but it also put everything basically into one line after the Where statement usually. I was just wondering if there is a way to turn this off so it will... -
Got it,
I set my field value to Date and used # # to surrond the date ie
I hate it when I find a solution 5 minutes after jumping on here ;)Code:< #01/01/2008#
Leave a comment:
-
Filtering Dates
Hi,
I am having a little trouble with some data I have been sent. Seems they want me to remove all the date that have a 5 year expiry date. I receive the data in csv file so the properties of the fields I can set in access to text or date which ever is needed. Atm I ran a sql query not like "*2013" which give me every thing before that year. I was wondering in the criteria box in access in expiry date field how to do this.... -
This is my new full query which seems to be able to give me a list of about 20 out of 1818 records that has bad address details. I'm sure there is a better way of doing it I'm just messing around in between jobs :). Once I run the query I mark a column value with a 1 that I deem no good then run a query to get those and email them to the customer saying these customers have not been mailed. Any tips to improve would be appreciated :)
...Leave a comment:
-
got it working.
Had a space " a-z" which threw it outLeave a comment:
-
I am using access 2003 if that matters.Leave a comment:
-
I get no results using that code. It does not seem to be working....Leave a comment:
-
should the character be entered like this
[a,b,c,d,e, etc] seem to be getting an error atm still playing with it.
its saying enter a parameter value atm.Leave a comment:
-
SQL Command
Hello,
I am just looking for the short command so I can bring up addresses that start with a letter A-Z and not a number. This is just so I can do a visual look over these address that don't start with a number and mark them of as bad and exclude them from mail merges etcI can then chase them up for next time. I presume there is something where in SQL I can go where like = "something * ". I have already got this working the... -
Easy formating
Hello all.
I have a column heading VIN with data like
MWN4567875PO456 789
What I need to do is a mail merge in word to create envelopes. I have the data in access. On the letter however need to print the last 10 values. Is there a easy way in SQL or access to create a column or crop that column to turn the values into
75PO456789
Even if its a solution in word to change it,... -
Fixed the problem thanksLeave a comment:
-
Yea the hammer and wrench is on the left hand pane. I'm using 2003 office. When I click on it I get a list, NO icons, one column. When I roll over it I get a pop up MORE CONTROLS. I cant see anything in there that says Page Break or Break in the list. There are no icons just a list.Leave a comment:
No activity results to display
Leave a comment: