Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. maryblu

    Excel XP Tabloid Printing

    I work with floor plans that were on Excel 97. We just migrated to XP and I can no longer select them to be printed on Tabloid paper. Can anyone tell me if this is an option in XP?
  2. maryblu

    Is it possible to query 5 different unrelated queries?

    Can you take 5 different queries with field names that are the same but that the data in these fields are not linked in any way? The five queries each have one table that is the same (Table 1)and each has one table (First query has table 1 & table 2, second query has table 1 & table 3, and so...
  3. maryblu

    Follow-up Question to preventing duplicate entries in a table.

    Thanks to Neufarth (MIS) for your helpful hint to Select Predicates in Access Help. But how would I write the instructions if I want all the entries along with just 1 of each duplicate entry? When I used the Sub query Select Distinct it gives me the duplicates only, not the rest of the entries...
  4. maryblu

    How do I prevent duplicate entries when data is inputed into a table

    I have a table in access that is fed directly from a system. the fields in the table refer to cases opened, worked, and then closed in this particular system. Each case has a specific number that is unique to the case but that case can be opened more than once and the case number stays the same...
  5. maryblu

    Reports:Not showing a field when it is 0

    I am working in a database that has tables that contain case types (text field) and the number of case types closed (unbound field) for individual employees. Each month a report will be generated for each employee with the total numbers of each case closed for their productivity. (There is other...
  6. maryblu

    On Reports, not showing a field if it is 0

    I am running a report that has case types as text names and the number of those case types closed in the unbound field. What I would like to do is run a report that will not show those text names if the number (in the unbound field) is 0. Is that possible or is the report like a template that...
  7. maryblu

    Writing a function using If, then, else in a query

    I would like to add a column in my query that asks the question if a certain field in my query is < or = to 5 then the number 184 should be entered if not then 224 should be entered. How do I build the the expression? The field I am refering to is Years of service (in a specific company) that...

Part and Inventory Search

Back
Top