Search results for query: *

I guess maybe I don't understand. I already have the records, can I convert them to text and how ? Please be simple because my expression understanding is simple. JR

I have a field that is set as date type Date/Time with the format set as Short Time. I have it set this way because I need to use military time. Unfortunately I also need to export the date to another Access Data base that needs to see the time as text instead of Date/time but still needs to be...

The Table would be called tblProduct. The Combo Field in the table is called Color. The table that holds the color value is called tblColor. 1;red;2;Blue;3;Green In the tblProduct, in the color field the data is shown as Red, Blue or Green. I need to run a report for the month and show how...

I want to show how many red and how many blue and how many green, plus the total number of all. JR

I have a table that has a color field set as a number field, Long Integer. Display Control = Combo Box Row Source Type = Table/Query Row Source = Color In the Color Table Red =1, Blue = 2 and Green = 3. The report need to be set up to report the info on each record, but then I need to pull out...

To Insert a value into a field from a Previous Record we can use CTRL + Apostrophe (') . I have a form with fifteen or so fields on it. I want to be able to fill in the form using the values from the previous record using eight or so fields, but not all of the fields from the previous form on...

I have a form that I would like to have opened Maximized each time a user opens it. I must be missing this as I can't imagine it is a difficult thing. Thanks JR

Thanks a bunch. As always, this is the place to come for the answer. JR

I am currently using the following expression which takes the entered date of Birth from the Date of Birth field and then populates the Age field with the persons age. Now I need to add the addition of populating a Year of Birth field with the year of birth. Your suggestions on the proper code...

And it did. Thanks

I need to generate a report that shows yesterday when run. What is the query parameter that will return yesterday in a date field

You folks are great to help out like this. The solution worked great. Thanks for all the input.

I wish to generate a report that first counts and shows the count of a number of entries. Then I need to count how many of those entries contain the letter P and show that amount. I am new at this so please be kind. bill