Search results for query: *

I have a report in Access that is a form letter (in details) that pulls a subreport when user sets a field to yes in a form. The form has the unit information and client code - its table is linked in a query the client table with names and addresses (to populate the details). it works fine...

I have a report in Access that is a form letter (in details) that pulls a subreport when user sets a field to yes in a form. The form has the unit information and client code - its table is linked in a query the client table with names and addresses (to populate the details). it works fine...

In other words, they don't want to type in the colon every time. If they type, for instance, 1555, I would like the cell to display 15:55 and be able to use this as a real time (in order to use it in formulas that find time differences). Is this possible? Thanks!

I have a report produced by another program that prints to a pdf. I can open and edit the pdf but the first page has a report explanation paragraph I need to remove. I removed the text using the touch-up text tool but I can't seem to move the rest of the page to the top. I tried using the...

I tried to search for this topic but came up empty. Trying to enter .5 in field. Set the field to number, long integer and changed "auto" decimal places to 2. No luck. Changed field size to double. Didn't work. So, I changed the field size to "decimal" and it finally worked. My question...

I did a search in Tek Tips on "unhide" and "unhide worksheet" but came up with nothing (didn't expect that!). I'm want to know if anyone has a quick & easy way to solve my dilemma. Otherwise I'll go to VBA . . . (in which I'm still a beginner) I have workbooks I use as quite often where I do...

I tried to search tek-tips for 'one-to-many' queries but couldn't find anything. I hope this isn't a really stupid question. I just can't figure it out I'm trying to match the numbers of consultants per service date with a table that has the service date's code as primary key. There can be...

I have a field with a person's name listed as "Smith,Mary" - I guess whoever created the table didn't think to separate the last name - yikes. I know how to separate this type of field in Excel(using the Text to Column). What should I do to separate it using an expression in a query? Any...

I have a table where there are many customer numbers. There could be more than one order for each on any given day. I only want to know the records where a customer orders unit #3 and THEN orders something else. So, my query output would show Customer Date Unit AAA 1/1/07...

I have a query where I was using datediff() to count the days between two dates and it worked fine. Now I need to count only the number of WEEKDAYS between two dates. I just have run out of ideas. Anyone know how I can do this? Thanks!

I have an Access database that I would like to write queries in. However, the database is read only to the people who do the data input. I know there is a simple shortcut to get to the database window but F11 doesn't work. I am sure the person who created the mdb put in a shortcut to open the...

I have an Access database that I would like to write queries in. However, the database is read only to the people who do the data input. I know there is a simple shortcut to get to the database window but F11 doesn't work. I am sure the person who created the mdb put in a shortcut to open the...

I have a graph where a have text boxes with one, two or three stars in various color above certain data points (months). This is a rolling 12-month chart. When a new month comes around I have to move ALL the text boxes because they're not attached to the data point. I tried to use "data...

Is there any way I can get a median and mode in a pivot table - or type of table.? I have a column of dates for an entire year, the days of the week that represent that date and the number of people per date. I want to show that on Mondays we had an average of 10.5, mode 9 etc. It would look...

I have a worksheet with approx. 50,000 rows. In column 3 I am trying to custom filter for "begins with" 10092. It comes up with nothing. I have used an asterisk after the number - no luck. I have ALSO used the "contains" without any rows coming up. So I dumped it in Access, ran a query in...

In column C I'm using the function =weeknum(b:1,2) where b:1 is the date. I want the week to start on Monday so I put the "2" in the parentheses. Works just fine until I get to 12/25/06. Then I find the value "53" in the column! Why am I getting an extra week in my year (not that I...

Any concise explanations or is it someone I need to research? Thanks!

I have cells in a column from F19 to F3205 to reformat. When I use the shortcut Shift Ctrl Down-arrow I only get to the next blank cell (F401)instead of the end of my data in that column (F3205). Any ideas for a shortcut? Thanks!

I need to have a set of random records with the criteria of a month start and end date. Can I do this in Access with VBA? I know that Excel has the RAND()function but I would like to be able to get my records right in the Access database. Any ideas? Thanks Thanks!

I need to pick 20 random files from a table with the only criteria is within a certain month. Can I do this through the Query by example without writing any code? Thanks!