Search results

This is a weird one - may not be a great solution to it - wondering if anyone has any insight into this.. I have a database that uses an Excel file as a linked table. I have to use the Excel file as a data source as this information is sent from a vendor to us. The Excel file has column A that...

I need to see if there is a way in a query to list rows of date vales between a given starting and ending date. Specifically the issue is - I have a table that has records with date values in a field. If for example my first date is 7/1/23 and my last date is 10/3/23 - I want to return a list of...

This is small conundrum but nevertheless kind of interesting. I made a form that is based upon a table. The form is just for entering data one record at a time. On this form I placed a button that opens the source table, for viewing in the more concise table view. I have noticed that if you...

Having a hard time putting a title on this one. This is odd. I seem to never have come across this before. Also possible that I am going senile and missing something obvious. Trying to figure out how to do this in a query. Example below. Let's say I have a table that looks something like this...

I must be missing something obvious on this. I have a query where I want to calculate an average of numbers in grouped field. I am simply using the QBE grid and then Totals - and then selecting the filed, and Avg. The results are displaying like this: AvgOfLENGTH 133 128 119.8 126.4...

I am hoping someone smart can take a look at the attached database and help me figure out a riddle. There is a form (frmMain). Upon opening the form there is an option to select a series - then a color (select *Show All for color). Now you have an option to select the items in the subform to...

I am trying to figure out a good way to deal with a linked table that has some spaces at the end of the data, and how to query for that. What I have is data in a field that looks like this: A A+ B B+ C C+ All of the one digit records actually have a space, in the field, after the single digit...

Struggling with this: I have a table with six fields. I want to update the values in the six fields, in one fell swoop, if possible. The six fields contain two digit codes (record values), or they are null. What I want is: set all field values, across the six fields, to null, unless the value in...

I have a query that is using a linked table for the data source. The query has a field that prompts the user to enter a warehouse code, to look up the records. The data on the source, or linked table, is all upper case. I found that if the user keys the warehouse code in lower case the query...

I have a report that is a label. It is designed to have two columns and ten rows of data. There is an image that is embedded on the report and should show up on each label. The image is a jpg. For some reason the image does not appear on each label. The image shows up on 11 of the twenty labels...

I have attached an example database of something I am trying to create. In the database there is a form: frmPrintLabels. If you open the form there is a list box called Series, if you select a series it loads the optional colors for the series in another listbox. If you select a color it...

Hello, Not sure if this is best posted in tables or not - so posting it here. I have a database that is used to create serialized stickers for inventory. I am using an auto-number field to give each record a unique serial number for labeling and barcoding. Currently to enter new records - prior...

Something I have never understood. If I have a report and it has controls (labels representing column titles) in the page header. Now when I print the report - if it happens that the last page has no detail records - but there is text boxes and so forth in the report footer. Is there a way to...

I have a form for data entry - and have an unbound text box on the form - formatted as short date. So on the form it has the calendar control to select the date (this is Access 2013). See attached - checkout. Now I want to use a query to retrieve the values on the form - see attached - Query1...

I know this has been brought up many times in various incarnations - however, despite much time spent Googling this the things I have tried thus far are not working. I have a link table that has a field that represents dates - but they are actually just text. It's a long story but the source is...

I have a weird one. I have a query that calculates days old (as in a number) of orders - that query look like this: DaysOld: Date()-[VORDDATE] That part (above) works fine. Now I am trying to make a report to allow the user to specify a parameter for number of days old to view on the report...

Does anyone know if it is possible to query a field for special characters in a string? I want to find any records that have characters other than A-Z, 0-9 Thanks!

I have a relatively small database. It has in it data relating to orders. The orders table has maybe twenty customers and their corresponding open orders. The number of customers with open orders will fluctuate from month to month. I want to send via e-mail a PDF or Excel file - monthly -...

Not sure this is the best way to go with this - but could not think of a more applicable title for the post. Basically I have an access database that has a report for quoting projects/jobs/materials. It all works pretty well...however, I have discovered that the user would like a good way to...

This has me stumped so far - I need to round up to the nearest nickel, preferably in a query. Have figured out how to round to the nearest nickel, but cannot get it to round up. I round to the nearest nickel like this: RoundedNumber: Round(20*[MyField],0)/20 Any ideas?