I have a problem with my query. How can I connect two tables with different fields. One of the tables has the date information and fiscal week. The other table has the # of units recieved. I created a date field in the table with # of units received to match the other. I have created a relationship between those two. I somehow need the query to show the # of units received by the fiscal week which is in the orginal table with dates. How can I make the query show # of units received by fiscal week.
What type of relationship do I need to establish since the date is a date field, # of units received is a number field and the fiscal week field is a text field.
What type of relationship do I need to establish since the date is a date field, # of units received is a number field and the fiscal week field is a text field.
