If I understand your suggestion it wouldn't work in my case because I have about 13,000 flight numbers to go through.
so my columns would look like this
source flight number
0 ab123
6 ab 123
7 ab 123
0 ac 12
7 ab 12
7 dc 124
6...
I stand corrected!!!!!!!!!!!!!!!!!!!!!!!!!
I read your reply but was not able to try it out at that time. I have tried it and it worked great. Sorry for doubting your suggestion, It was easier than I thought.
Thanks again
Thanks for your reply but I don't think that would work. I will try. This may be a better description...
Some flight number only appear once, some may appear 10 times. If the heading was part of the flight number then it would appear before each flight.
Well say on my report I have 100 rows of...
I have a field (called source) that will have a 0,6, or a 7 as it's data.
I then have a field that has a flight number (input as a text since it is comprised of both letters and numbers).
Some of these flight numbers appear three or more times once with a 0, once with a 6, and once with a 7...
In a report that I had created it displays the results of a query. We will say the columns are: Unit,Depart area, flight number, and destination. The query places this information sorted in the order I want. The problem is when the report is made it displays the titles for the columns at the top...
I have a feeling this is an easy one but not easy enough for someone like me.
I have created a database to keep track of all of the equipment in my office. (I am in the Army so we have a lot and of course we track it all with serial numbers...). Anyway, we will say computers and printers. I...
Hello,
Whenever I print information from my database as it gets further down the page the information starts to get printed ontop of the lines, and no longer stays within the boxes created.
any help would be greatly appreciated.
Is this a printer problem?
SFC Reed
I won't be able to test the computer for a couple of days. (I am in the Army stationed in Korea, and the computer is on another post).
However, I failed to mention that when you are typing in the field if you hit the right arrow key the cursor will move and accept the next letter in your entry...
Hello,
I had created this database and made several copies of it to install onto other computers. When I gave a copy to a co-worker we ran into a problem...
When it brings up a form and you go to type the information in the cursor does not move. Instead it just types on top of the letter you...
Hello,
I have created a database to keep track of soldiers here in Korea. I have a query that finds soldiers who are scheduled to leave (Korea) in 30 days. It uses this...
Between Date() And DateAdd("d",30,Date())
It works great but I realize that if that soldier is not erased from the...
Hello,
Ok I have been trying to learn access and I made a great database for use here at work. While creating it I thought it would be neat to make a security feature to it. Well now I am using that database to make a smaller database to give to people to use and send me their reports...
This is what I have it doing currently....
When you start your computer you can click on the icon and the database will open. If you do that while holding down the shift key it will show you the menu bar and tool bar. However if you add any information into the database and exit. You can not...
Hello,
I have a database I created using MS Access. I had installed security groups and so now it prompts for username and password. I had also made a custom menu bar (no controls). I did leave the hot keys in place so I can still make changes however, now I am trying to make copies of some of...
Hello,
I have two text boxes one is named "WARDENS ASSIGNED" and the other "MIN WARDENS NEEDED". I was hoping there was a way that IF WARDENS ASSIGNED < MIN WARDENS NEEDED then forecolor is red else blue?
If there is such a code I would also need to know where to place it. Both of these text...
Awesome,
You have no idea how much you all just helped me.
Just so you can possibly get a little gratification...
I am in South Korea and this database keep tracks of all the people (wardens) who ensure noncombatants (civilian businessmen, military families.....) are taken care of and alerted...
...but now that I got that to work (actually the only one I was able to get working was the =DCount("[Duty Pos]", "[NEO II]", "[Duty Pos] Like '*WARDEN*'")
I was wondering if there was a way I could add a where statement to this.
Another field in my database is "MSC" which is a list of...
Sorry,
I owe you all a big apology, and a thank you. As I was double checking everything I realized that "Duty Position" was changed to "Duty Pos" so now I got it to work. I had shortened the name so it would fit better in the title bar of the spreadsheet.
Thank you for your patience and all...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.