Search results for query: *

The table with the clients' names has the master field & the units has the child field. (One to Many) The source of the main report (the addresses) is clients table - master field - and the subreport is child. Thanks!

Accidentally Posted my question here - reposted in the Access Reports forum. Thanks. Thanks!

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...

Okay . . . I'm a dope. Thanks. Thanks!

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...

Thanks very much MoLaker and dhookom. Your latter posts are VERY helpful (yeah, I shouted VERY). I'm sorry I shorted out a bit. I've been dealing with problems such as this: 1. Internet is down. 2. Called the help desk. 3. Put on hold by the help desk for eight minutes with scratchy musak...

I'm sorry but I'm not understanding something. Is there a problem with my posting a simple question? PHV, obviously I'm not an I.T. guru in charge of fixing the Access help or I wouldn't have posted at all. dhookom,you state "There have been lots of threads regarding this issue" but I used the...

dhookom, The help function on our network version of Access isn't working or I would have looked up the left, right and mid. One question for you - how would get the left function to return a name if all the names are different number of characters? Thanks!

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!

Thanks - holding the shift-key and opening from the windows explorer worked. Sorry about the double post. I showed my coworker my post & she thought I put my question in the wrong forum so I posted again. Again, thank you both for answering! 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...

That first idea didn't work out, unfortunately. Do you know a simple macro that might work - or am I asking for too much help? I appreciate it. Thanks!