criteria

[bluey]

I did not ask this very well last time so im trying to be clearer

i was wondering if anyone knows of any expressions or code or filters or somthing that can sort and update records. well sort of filter/criteria limiter

So say "hello" and "Tuesday" have automatically been entered.

and you witsh to add "shards" to another field so all
the "hello" "tuesdays" have "shards" added to them.

I would like it if all the days of the week could have this done to them so you could type "ted" "tuesday" or "jim"or "wednesday" or "eggs" "thursday" and so one.which perhaps with the help of a macro could produce:

Name|weekday| Name2

Hello| Tuesday| shards| like this

 

[The_Doc_Man]

Is this some attempt at generating a type of cypher/encryption/encoding?

I'm afraid you will have to do some rather complex string operations on this type of thing. Basically, though you could do it in Access using perhaps some VBA code, you are going to have to fight the nature of Access. Word macros might be better suited than Access modules.

And no, a filter isn't going to do this for you at all. I don't know what you are trying to do, but it seems to not be related to the type of thing that Access normally does.

 

[bluey]

hope fully this will help i only do this when im having trouble with my explinations.

I have to do it this way because it would take to long to type in the names myself.

All the data in this mock form has been automatically updated using querys and macros

I need to somehow to tell access that i want to add my new
name to 06/01/02 /harry/1/sunday or any other day like this.

my sub form looks like this at the moment:

Date \ Name\wno\day \ New name\
06/01/02\ Harry \ 1 \sunday \ [#####]
07/01/02\ Harry \ 2 \monday \
08/01/02\ Harry\3 \tuesday \
09/01/02\ Harry \4 \wednesday\
10/01/02\Harry \ 5 \thursday \
11/01/02\Harry \ 6 \Friday\
12/01/02\ Harry bob\7 \Saturday \

I guess no body knows how to do this oh well ile keep trying to do it myself.