Re: Creatinig a database to update in alphabetical order

Where the data is in a table is irrelevant in Access. Use a query with the
appropriate ORDER BY clause to display the data, and it doesn't matter how
it was updated.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"RagghiantiGirl" <RagghiantiGirl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:79BD8FA0-B97A-4297-8490-78FE564FABF4@xxxxxxxxxxxxxxxx
> Is there a way to use Access, or Excel, to create a database, that I can
> use
> a command to update it in alphabetical order?


.

Relevant Pages

  • Two queries
    ... the Allocated table) I want it to display the product quantity from the ... How do I set up the query to do this? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: IIF Statement In Query Doesnt Work Right
    ... Switch the query to SQL View. ... A WHERE clause ultimately is an expression that returns a True or False For each record where it evaulates to TRUE, the record is included; ... query must display ALL its values, and if it isn't, it must display only ... if I was to get rid of the IIF statement all together and replace it ...
    (microsoft.public.access.queries)
  • Populate a List Box to select a record
    ... I use the same form to display different sets of records from a query that ... I limit or filter for different subsets by using the ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Combo box requery; update underlying table
    ... The display is ... but the value is not retained in the underlying table. ... The form is based on a query. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • pivot table not running correctly..
    ... i have pivots table in different Projects which were running correctly, ... suddenly all of them stoped running correctly and display this message ... "The query could not be processed: ... Prev by Date: ...
    (microsoft.public.access.forms)